Difference between revisions of "Documentation/FAQ/Macros"

From Apache OpenOffice Wiki
Jump to: navigation, search
(How can I assign a macro to a key?)
Line 12: Line 12:
 
Now an <b>F3</b> keystroke will run the macro. If you save it under <b>soffice</b>, it will be available in all your OpenOffice.org documents.
 
Now an <b>F3</b> keystroke will run the macro. If you save it under <b>soffice</b>, it will be available in all your OpenOffice.org documents.
  
 +
 +
==How can I make a macro available for all new docs?==
 +
# Open the document containing the macro.
 +
# Go to Tools > Macro > Macro.
 +
# On the Macro dialog, click on Organizer.
 +
# On the macro organizer dialog, click on the Libraries tab.
 +
# Make sure that soffice is selected under Application/Document. Then click on Append.
 +
# Select .odt and click on Open. Make sure that the library called is selected. NOTE: The library called Standard should not be selected. Then press OK.
 +
 +
The library should now be available to every OpenOffice.org document.
  
 
==Can I use my Microsoft Office macros?==
 
==Can I use my Microsoft Office macros?==

Revision as of 00:34, 12 August 2007

doc OOo



How can I record a macro?

Go to Tools > Macros > Record Macro, then press the sequence of keystrokes you want. At the end of your sequence click on Stop Recording. In the new window that pops up, give the file a name and save it under soffice > Standard > Module1.


How can I assign a macro to a key?

  1. Go to Tools > Macros > Macro..., select the macro you wish to assign to a keystroke, then click Assign.
  2. Under the Keyboard tab, select some unused key for this action, like F3 for instance.
  3. Click on Modify, then OK, then Close.

Now an F3 keystroke will run the macro. If you save it under soffice, it will be available in all your OpenOffice.org documents.


How can I make a macro available for all new docs?

  1. Open the document containing the macro.
  2. Go to Tools > Macro > Macro.
  3. On the Macro dialog, click on Organizer.
  4. On the macro organizer dialog, click on the Libraries tab.
  5. Make sure that soffice is selected under Application/Document. Then click on Append.
  6. Select .odt and click on Open. Make sure that the library called is selected. NOTE: The library called Standard should not be selected. Then press OK.

The library should now be available to every OpenOffice.org document.

Can I use my Microsoft Office macros?

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.


Where can I find more info about macros?

The OpenOffice.org API project is the OOo project that works the most with macros.

Additional resources for macros:

Personal tools