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, Collabora Office 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 Collabora Office Basic macros.
Since support for VBA is not complete, you may have to edit the VBA code and complete the missing support with Collabora Office Basic objects, statements and functions.
Editar macros VBA
As macros VBA podem ser editadas no IDE do Collabora Office Basic.