Trabalhar com macros VBA

O Visual Basic for Applications (VBA) é uma implementação do Visual Basic da Microsoft existente nas aplicações do Microsoft Office.

Support for VBA is not complete, but it covers a large portion of the common usage patterns. Most macros use a manageable subset of objects in the Excel API (such as the Range, Worksheet, Workbook, etc.) and the support include those objects, and the most commonly used method/properties of those objects.

Carregar documentos do Microsoft Office com macros VBA executáveis

Choose - Load/Save - VBA Properties and mark the Executable code checkbox. Then load or open your document.

Código executável

O código VBA (Visual Basic for Applications) será carregado pronto para ser executado. Se esta caixa de verificação não estiver marcada, o código VBA será comentado para poder ser inspeccionado, mas não será executado.


After loading the VBA code, LibreOffice inserts the statement Option VBASupport 1 in every Basic module to enable a limited support for VBA statements, functions and objects. See Option VBASupport Statement for more information.

Running VBA Macros

Run VBA macros in the same way as LibreOffice Basic macros.

Ícone de aviso

Since support for VBA is not complete, you may have to edit the VBA code and complete the missing support with LibreOffice Basic objects, statements and functions.

Editar macros VBA

As macros VBA podem ser editadas no IDE do LibreOffice Basic.

Necessitamos da sua ajuda!