|
|
(13 intermediate revisions by 5 users not shown) |
Line 1: |
Line 1: |
| {{Documentation/FAQTOC}} | | {{Documentation/FAQTOC}} |
| + | {{DISPLAYTITLE:{{AOo}} Macros FAQ}} |
| + | Search the FAQs: <googlefaq/> |
| + | This list is ordered by popularity. The most popular FAQs are at the top. But also have a look at the bottom to find any new entries. |
| | | |
− | ==How can I record a macro?== | + | <DPL> |
− | 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>.
| + | category=Documentation/FAQ/Macros |
| + | ordermethod=counter |
| + | order=descending |
| + | replaceintitle=/Documentation.*\//, |
| + | secseparators=<br> |
| + | </DPL> |
| | | |
| | | |
− | ==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.
| |
| | | |
| + | <table border=1 cellpadding=5 style="width:100%; border-collapse: collapse; border-color:#AAA; background-color:#EEE;"><tr> |
| + | <td> |
| + | ===Add a new FAQ entry=== |
| + | <inputbox> |
| + | bgcolor=#EEE |
| + | type=create |
| + | default=Documentation/FAQ/Macros/<FAQ_TITLE> |
| + | preload=Documentation/FAQ_Template |
| + | buttonlabel=Add new FAQ |
| + | break=no |
| + | </inputbox> |
| + | '''Instructions''' |
| + | * Do '''not ask questions''' here, but '''give answers'''. |
| + | * If you have a '''question to ask''', go to the [https://forum.openoffice.org/en/forum/ User Forum]. |
| + | * Replace ''<FAQ_TITLE>'' part in the input box above by the title you would like to give the FAQ item and click '''Add New FAQ''' |
| + | </td></tr></table> |
| | | |
− | ==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.
| + | [[Category: Documentation/FAQ]] |
− | | + | [[Category:User FAQ]] |
− | ==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]
| + | |
This list is ordered by popularity. The most popular FAQs are at the top. But also have a look at the bottom to find any new entries.