2008/4/27 Ferruccio Riva <[EMAIL PROTECTED]>: > I'd like to substitute my MSOffice with OpenOffice, but I have created a > lot of macros wrote in the MS Excel 5.0 version for special purposes. > Is OpenOffice able to read and use that macros? > Thank you for the attention. > > Ferruccio Riva
Hello, This is what the Help says about MSoffice macros: > Macros in Microsoft Office and OpenOffice.org > Microsoft Office and OpenOffice.org cannot run the same macro code. > Microsoft Office uses VBA (Visual Basic for Applications) code, and > OpenOffice.org uses Basic code based on the OpenOffice.org API (Application > Program Interface) environment. Although the programming language is the > same, the objects and methods are different. > 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. > OpenOffice.org can load the macros that are contained within Microsoft > Office files and you can then view and edit the macro code in the > OpenOffice.org Basic IDE editor. > You can choose to preserve or delete VBA macros > Open a Microsoft Office document that contains VBA macro code. Change only > the normal contents (text, cells, graphics), and do not edit the macros. > Save the document as a Microsoft Office file type. Open the file in > Microsoft Office, and the VBA macros will run as before. > You may delete the VBA macros from the Microsoft Office file on loading or > on saving. > Choose Tools - Options - Load/Save - VBA Properties to set the VBA macro > handling of OpenOffice.org. > > -- Guy using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard -- please reply only to [email protected] -- Dodoes can't afford to have headaches
