Using Macros

From NeoWiki

Revision as of 19:23, 5 May 2007 (edit) Lorinda (Talk | contribs) (added information from link about recording a macro) ← Previous diff		Revision as of 19:34, 5 May 2007 (edit) (undo) Lorinda (Talk | contribs) (→Saving Code as a Macro - de-stubbifying Saving Code as a Macro) Next diff →
Line 25:		Line 25:
	==Saving Code as a Macro==		==Saving Code as a Macro==
-	There is a thread in trinity about [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=31433#31433 saving code as a macro]	+	Sometimes you may find code provided in a forum or in a text document that you want to add as a macro. To do so, follow these steps:
		+
		+	*Under the {{menu|Tools}} choose {{menu|Macros}} then {{menu|Organise Macros}} and Finall {{menu|NeoOffice Basic...}}
		+	*Note that if the code is written in something other than NeoOffice/OpenOffice.org Basic, you need to choose the corresponding language at this point.
		+	*Choose the Library and Module where you want the Macro to be stored in the left panel
		+	**e.g. in My Macros-Standard-Module1 (it highights this by default)
		+	*Make sure that "Main" is highlighted in the right panel
		+	*click on {{menu|Edit}}.
		+	*Paste the code in anywhere below the Main/End Sub lines - making sure you don't paste in the middle of any other macros you saved; a couple of lines after Main's End Sub line is an obvious choice.
		+	*Click {{menu|Save}}
		+
	<br><br>		<br><br>
		+
	==Documentation/Support for Macros==		==Documentation/Support for Macros==
	Chapter 10 of the [http://www.geocities.com/aussie_149/NeoUGWebsite/index.html NeoOffice User Guide] (draft) discusses Basic and Macros.		Chapter 10 of the [http://www.geocities.com/aussie_149/NeoUGWebsite/index.html NeoOffice User Guide] (draft) discusses Basic and Macros.

---

Revision as of 19:34, 5 May 2007

Contents 1 Recording a Simple Macro 2 Assigning a Shortcut Key to a Macro 3 Saving Code as a Macro 4 Documentation/Support for Macros 5 Sources of Macros

Recording a Simple Macro

1. Go to [meun|Tools], choose Macros and then Record Macro
2. Perform the series of steps you want the macro to do for you automatically. (For example, apply a particualr style)
3. When you have finished all the steps, click on Stop recording
4. In the window that appears, give the macro a name.
5. Assign the macro to a Library and Module (See chapter 10 of the NeoOffice User Guide mentioned below for more information)
6. Click Save when you have the settings the way you want

Assigning a Shortcut Key to a Macro

1. Go to Tools>Customize...
2. Click on the Keyboard tab
3. In the Category box, scroll down to "NeoOfficeMacros" and highlight it
4. Burrow your way down through "user" and the library and module your macros are stored in. Eventually your new macros will be listed in the Function box
5. Highlight one of those macros
6. In the Shorcut Keys box select the key you want to assign to that macro
7. Set the radio button to specify if the key assignment is for all of NeoOffice or only for Writer
8. click Modify

Saving Code as a Macro

Sometimes you may find code provided in a forum or in a text document that you want to add as a macro. To do so, follow these steps:

• Under the Tools choose Macros then Organise Macros and Finall NeoOffice Basic...
• Note that if the code is written in something other than NeoOffice/OpenOffice.org Basic, you need to choose the corresponding language at this point.
• Choose the Library and Module where you want the Macro to be stored in the left panel
  • e.g. in My Macros-Standard-Module1 (it highights this by default)
• Make sure that "Main" is highlighted in the right panel
• click on Edit.
• Paste the code in anywhere below the Main/End Sub lines - making sure you don't paste in the middle of any other macros you saved; a couple of lines after Main's End Sub line is an obvious choice.
• Click Save

Documentation/Support for Macros

Chapter 10 of the NeoOffice User Guide (draft) discusses Basic and Macros.

The Getting Started with Macros Guide to OpenOffice.org can be downloaded with this link Just remember to use the command key where the OpenOffice guide says to use the control key.

Andrew Pitonyak has both a free downloadable document on OpenOffice Macros and a book that you can purchase.

The OpenOffice.org Macros and API forum is a good source of information on Macros.

Sources of Macros

OOoMacros.org has a library of macros available for download.