Difference between revisions of "Documentation/FAQ/Macros"

From Apache OpenOffice Wiki
Jump to: navigation, search
(added search)
 
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
{{Documentation/FAQTOC}}
 
{{Documentation/FAQTOC}}
{{Documentation/NeedsRework}}
 
 
{{DISPLAYTITLE:{{OOo}} Macros FAQ}}
 
{{DISPLAYTITLE:{{OOo}} 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.
 
  
The above is incorrect:
+
<table border=1 cellpadding=5 style="width:100%; border-collapse: collapse; border-color:#AAA; background-color:#EEE;"><tr>
# Go to <b>Tools > Customize</b>.
+
<td>
# Select <b>Keyboard</b> Tab.
+
===Add a new FAQ entry===
# Under <b>Category</b>, select <b>OpenOffice.org Macros</b>.
+
<inputbox>
# Browse to the Macro containing the desired Function.
+
bgcolor=#EEE
# Under <b>Function</b>, select the desired function.
+
type=create
# Under <b>Shortcut keys</b>, browse to and select the desired shortcut key.
+
default=Documentation/FAQ/Macros/<FAQ_TITLE>
# Click on <b>Modify</b>. The shortcut key now appears under <b>Keys</b>.
+
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 [http://user.services.openoffice.org 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]
+

Latest revision as of 12:51, 17 November 2010

doc OOo



Search the FAQs:

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.



Add a new FAQ entry

Instructions

  • Do not ask questions here, but give answers.
  • If you have a question to ask, go to the 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
Personal tools