Save the document as a Microsoft Office file type. Change only the normal contents (text, cells, graphics), and do not edit the macros. Open a Microsoft Office document that contains VBA macro code. You can choose to preserve or delete VBA macros LibreOffice can load the macros that are contained within Microsoft Office files and you can then view and edit the macro code in the LibreOffice Basic IDE editor. If you use macros in one of the applications and want to use the same functionality in the other application, you must edit the macros. The most recent versions of LibreOffice can run some Excel Visual Basic scripts if you enable this feature at LibreOffice - PreferencesTools - Options - Load/Save - VBA Properties. Although the programming language is the same, the objects and methods are different. Microsoft Office uses VBA (Visual Basic for Applications) code, and LibreOffice uses Basic code based on the LibreOffice API (Application Program Interface) environment. With a few exceptions, Microsoft Office and LibreOffice cannot run the same macro code. Macros in Microsoft Office and LibreOffice

Choose File - Wizards - Document Converter to start the wizard.

You can specify the folder to be read, and the folder where the converted files are to be saved. The Document Converter Wizard will copy and convert all Microsoft Office files in a folder into LibreOffice documents in the OpenDocument file format. Of course, you still can select another file type in the file save dialog.Ĭonverting Many Microsoft Office Files into OpenDocument Format

In the Default file format and ODF settings area, first select a document type, then select the file type for saving.įrom now on, if you save a document, the File type will be set according to your choice.

Choose Tools - Options - Load/Save - General.

Saving Documents by Default in Microsoft Office Formats

In the File type box, select a Microsoft Office file format.

Select a Microsoft Office file in the LibreOffice file open dialog.

5.1 You can choose to preserve or delete VBA macros.

5 Macros in Microsoft Office and LibreOffice.

4 Converting Many Microsoft Office Files into OpenDocument Format.

3 Saving Documents by Default in Microsoft Office Formats.

Download libreoffice help module