Working with VBA Macros
Visual Basic for Applications (VBA) is an implementation of Microsoft's Visual Basic which is built into all Microsoft Office applications.
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.
Loading Microsoft Office documents with executable VBA macros
Choose Collabora Office - PreferencesTools - Options - Load/Save - VBA Properties and mark the Executable code checkbox. Then load or open your document.
可執行的程式碼
將載入 VBA (Visual Basic for Applications) 程式碼並準備執行。若未核取此核取方塊，VBA 程式碼會加註為註解以進行檢查，但不會執行。
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.
Editing VBA Macros
VBA macros can be edited in the Collabora Office Basic IDE.