Finding more information

From Apache OpenOffice Wiki
Jump to: navigation, search

Numerous resources are available that provide help with writing macros. Use Help > Help to open the OOo help pages. The upper left corner of the OOo help system contains a drop-down list that determines which help set is displayed. To view the help for Basic, choose Basic from this list.

Included material

Many excellent macros are included with OOo. Use Tools > Macros > Organize Macros > Basic to open the Macro dialog. Expand the Tools library in the library container. Inspect the Debug module—some good examples include WritedbgInfo(document) and printdbgInfo(sheet).

Online resources

The following links and references contain information regarding macro programming:

Printed and eBook materials

The following books are available for purchase in both printed and eBook form from their publishers.

Andrew Pitonyak's Macros Explained. See

Dr. Mark Alexander Bain's Learn Spreadsheet Macro Programming. See

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools