Macros are very popular when it comes to the automation of program processes. How to create in the spreadsheet OpenOffice Calc macros, you will learn in this article.
OpenOffice Calc: Macro Recorder
"OpenOffice" is a free and very good Alternative to Microsoft Office. Similar to how in Excel, you can create in the spreadsheet OpenOffice Calc macros. You can either record macros or programming. In the latter case, you need to have basic knowledge of the programming language OpenOffice.org Basic.
- Start recording: to start recording a Macro, go to the menu bar, click "tools" -> "macros" -> "record Macro". The program now logs in the Background of their activities. Next, perform your step you want to automate. You can, for example, create a chart with empty values. If you enter in a later step, the values in the table and run the Macro, this is filled in automatically. When you finish recording, click stop recording. After that, you need to give the Macro a name and save it.
- Running a macro: To run a macro, you need the "Java Runtime Environment". If this is not installed on your PC, you can get a note from OpenOffice. Make sure for safety reasons that the current Version is installed. A recorded Macro, go to the menu bar, click "tools" -> "macros" -> "run Macro...".
- Add icon: If you want to reach your Macro directly by icon, click in the toolbar on a grey arrow, and then click "customize toolbar...". With the "Add..." allows you to place new items on your toolbar. The last entry in the field "field" contains the macros. With the arrows specify the Position of the macro.
Calc: record Macro
OpenOffice Calc: Macro programming
If you are with the program, you can create a Macro yourself. OpenOffice has its own development environment. Detailed instructions can be found on the Wiki page of the manufacturer.
- The basic structure: such As the basic looks of the scaffolding, you can refer to a recorded Macro. Go to the menu bar, click "tools" -> "macros" -> "manage" -> "OpenOffice Basic...". Select your Macro and click "edit...". In the development environment (IDE) you can write your own source code.
OpenOffice Calc: IDE
If you find yourself repeating certain steps in every file you edit in Open Office Writer, you can save time by combining those tasks into macros. We'll show you how to create and run macros in Open Office to carry out repetitive tasks like inserting pre-made signatures and formatting memos.
-
1
Enter the text for the memo heading macro. Open a new OpenOffice document and enter the text. Type "To:" and press enter. Type "From:" and press enter. Type "Date:" and press enter again. Type "RE:" and press enter twice. Then type "Message:" The text has been entered.
-
2
Format the text for the memo heading. Click and drag to select the text. Click the Bold button on the toolbar. Select the Format tab on the menu bar and choose Paragraph from the pull-down menu. The Paragraph dialogue box will open.
- Click
the Tabs tab and enter "1" into the Position field located on the far left. In the Type menu to the right, be sure that "Right" is selected and press OK. The inter-office memo heading has been formatted.
- Click
the Tabs tab and enter "1" into the Position field located on the far left. In the Type menu to the right, be sure that "Right" is selected and press OK. The inter-office memo heading has been formatted.
-
3
Remove the memo heading from the document by selecting all of the text and cutting it to the clipboard. Right click on the selected text and choose cut from the pull-down menu. The text has been removed from the document, but remains on the clipboard.
-
4
Create or "record" the memo heading macro. Select the Tools tab on the menu bar, click Macros, and select Record Macro from the pull-down menu to begin the recording process. The Record macro pop-up box will appear and the recording process begins.
- Right-click at the insertion point for the memo macro and select paste from the pull-down menu to reinsert the formatted memo text into the document.
- Click the Stop recording button located in the Record macro pop-up box. The Basic macro dialogue box will open. Enter a title for the new macro in the field on the upper-left, and click the Save button. The memo heading macro has been recorded.
-
5
Test the memo macro by executing or "running" the macro. Select the tools from the menu bar, click Macros and select Run from the pull down menu. The Macros dialogue box will open. Double click My Macros located in the column on the left, then double click Standard. Double-click the title you entered for the memo heading macro.
- Click on the newly created memo macro to highlight it and click the "Run" button. The pre-formatted text for the memo heading will be inserted automatically. The memo macro has been run.
-
1
Enter the text for the signature macro. Type your name on the first line and press enter. On the next line, type your job title and press enter. On the next line, type the company name. Type your contact information on the last line and press enter again. The text for the signature macro has been entered.
-
2
Format the text for the signature macro. Select the text and click the Format tab on the menu bar. Choose Paragraph from the pull-down menu and click the Indents and Spacing tab in the Paragraph dialogue box. The text for the signature macro has been formatted.
-
3
Remove the text from the document by cutting it to the clipboard. Click and drag to select the text. Right click on the selected text and choose cut from the pull-down menu to copy the text to the clipboard while removing it from the document at the same time. The text has been removed from the document, but remains on the clipboard.
-
4
Create or "record" the signature macro. Select the Tools tab on the menu bar, click Macros, and select Record Macro from the pull-down menu to begin the recording process. The Record macro pop-up box will appear and the recording process begins.
- Right-click at the insertion point of the signature macro and select paste from the pull-down menu to reinsert the formatted signature into the document. Click the Stop recording button located in the Record macro pop-up box. The recording process is complete and the Basic macro dialogue box will open.
- Enter a title for the new macro in the field on the upper-left, and click the Save button. The signature macro has been recorded.
-
5
Test the signature macro by "running" or executing the macro. Select tools from the menu bar, click Macros and select Run from the pull down menu. The Macros dialogue box will open. Double click My Macros located in the column on the left, then double click Standard. Double-click on the title you entered for the signature macro to execute or "run" the signature macro. The signature macro has been run.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Video
References
About this article
Thanks to all authors for creating a page that has been read 52,662 times.