Difference between revisions of "Documentation/FAQ/Macros"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
Line 1: Line 1:
 
{{Documentation/FAQTOC}}
 
{{Documentation/FAQTOC}}
{{Documentation/NeedsRework}}
 
 
{{DISPLAYTITLE:{{OOo}} Macros FAQ}}
 
{{DISPLAYTITLE:{{OOo}} Macros FAQ}}
  
Line 20: Line 19:
 
</inputbox>
 
</inputbox>
 
</td></tr></table>
 
</td></tr></table>
 
==How can I record a macro?==
 
Go to <b>Tools > Macros > Record Macro</b>, then press the sequence of keystrokes you want. At the end of your sequence click on <b>Stop Recording</b>. In the new window that pops up, give the file a name and save it under <b>soffice > Standard > Module1</b>.
 
 
 
==How can I assign a macro to a key?==
 
# Go to <b>Tools > Macros > Macro...</b>, select the macro you wish to assign to a keystroke, then click <b>Assign</b>.
 
# Under the <b>Keyboard</b> tab, select some unused key for this action, like <b>F3</b> for instance.
 
# Click on <b>Modify</b>, then <b>OK</b>, then <b>Close</b>.
 
 
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.
 
 
The above is incorrect:
 
# Go to <b>Tools > Customize</b>.
 
# Select <b>Keyboard</b> Tab.
 
# Under <b>Category</b>, select <b>OpenOffice.org Macros</b>.
 
# Browse to the Macro containing the desired Function.
 
# Under <b>Function</b>, select the desired function.
 
# Under <b>Shortcut keys</b>, browse to and select the desired shortcut key.
 
# Click on <b>Modify</b>. The shortcut key now appears under <b>Keys</b>.
 
 
==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?==
 
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 [http://api.openoffice.org/ API project] is the OOo project that works the most with macros.
 
 
Additional resources for macros:
 
 
* [http://www.oooforum.org/forum/viewforum.php?f=9">Macros and API Forum]
 
* [http://scripting.openoffice.org/ Scripting Project]
 
* [http://api.openoffice.org/DevelopersGuide/DevelopersGuide.html Developer's Guide]
 
* [http://ext.openoffice.org.nz/doku.php OpenOffice.org Extensions Wiki]
 
* [http://www.ooomacros.org/ OOoMacros]
 
* [http://homepages.paradise.net.nz/hillview/OOo/ Iannz OpenOffice.org page]
 
* [http://www.pitonyak.org/oo.php">Andrew Pitonyak's OpenOffice.org Macro Information page]
 
* [http://www.darwinwars.com/lunatic/bugs/oo_macros.html">Andrew Brown's Open Office Macro Page]
 
* [http://documentation.openoffice.org/manuals/oooauthors2/ Getting Started with Macros]
 
* [http://documentation.openoffice.org/manuals/oooauthors2/ Introduction to Macros]
 
* [http://docs.sun.com/db/doc/817-1826?q=StarOffice Sun's Basic Programmer's Guide]
 

Revision as of 15:05, 27 October 2008

doc OOo




Personal tools