This becomes a major issue in migrating to OOo. So VBA macros have to be rewritten in OOBasic to avail the same functionality in OOo. When an MS Office document is opened in OOo, the VBA macros present in them are unusable under most circumstances. Well, many organisations are migrating to OOo nowadays, but a lot of their old documents are in the MS Office format. You may wonder about the need for such a discussion in a FOSS article. Visual Basic for Applications (VBA) is an implementation of Microsoft’s Visual Basic integrated into Microsoft Office applications. ABC Auditing should have chosen the right version when it decided to migrate to OOo. Thankfully, this is not a dream and is possible with some versions of OOo that support VBA. The manager now wishes he had a copy of OOo that could handle VBA also. This may take some time and money, as going back to the old environment is not an option any longer.
They may need a developer to rewrite VBA code in OOBasic. Suddenly, however, it’s noted that a few important Excel (spreadsheet) documents with macros are not functioning properly in OOo. The firm gets a copy of OOo installed on every machine and trains its employees to work with documents in ODF (Open Document Format), as well as with older documents that were prepared in the MS Office format, in OOo. The ABC Auditing Company decides to migrate to.
0 kommentar(er)
