Difference between revisions of "Documentation/FAQ/Macros/Can I use my Microsoft Office macros?"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE: Can I use my Microsoft Office macros?}} <section begin=question/> '''Can I use my Microsoft Office macros?''' <section end=question/> <section begin=answer/> Even though ...)
 
 
Line 6: Line 6:
  
 
<section begin=answer/>
 
<section begin=answer/>
Even though the OpenOffice.org macros are written in a form of StarBASIC, it isn't the same as what Microsoft uses. Macros written for MS Word or Excel for instance cannot be executed via OpenOffice.org; you'll need to re-write them. This has its benefits - it makes OOo documents less virus prone.
+
The OpenOffice.org macros are written in OpenOffice.org BASIC, a macro language that uses the same programming logic as Microsoft Visual Basic. However, some elements differ, as for example the calls to software commands and object names. So you would have to rewrite the macros. Macros written for MS Word for instance cannot be executed via OpenOffice.org; you'll need to re-write them. This has its benefits - it makes OOo documents less virus prone.
 +
 
 +
OpenOffice.org 3 Calc can execute many Excel macros, but (for security reasons) you must manually enable this feature. Choose '''Tools > Options > Load/Save > VBA Properties''' and enable the '''Executable code''' checkbox.
  
 
<section end=answer/>
 
<section end=answer/>
  
 
[[Category:Documentation/FAQ/Macros]]
 
[[Category:Documentation/FAQ/Macros]]

Latest revision as of 09:55, 19 November 2008


Can I use my Microsoft Office macros?


The OpenOffice.org macros are written in OpenOffice.org BASIC, a macro language that uses the same programming logic as Microsoft Visual Basic. However, some elements differ, as for example the calls to software commands and object names. So you would have to rewrite the macros. Macros written for MS Word for instance cannot be executed via OpenOffice.org; you'll need to re-write them. This has its benefits - it makes OOo documents less virus prone.

OpenOffice.org 3 Calc can execute many Excel macros, but (for security reasons) you must manually enable this feature. Choose Tools > Options > Load/Save > VBA Properties and enable the Executable code checkbox.


Personal tools