How can we help you?

A macro is a set of actions that automate repeated or time-consuming tasks in a document. MyOffice Text macros are written in Lua programming language.

Macros are most commonly used for the following purposes:

To input data

To find and replace data throughout the text

To clear data

You can save macros only within the current document. To use a macro in other documents, create it directly in these documents.

Create a macro

1.In the Command menu, click Tools > Macro Editor.

2.In the Macro Editor window that appears, click macros_add_script_icon.

3.Enter the new macro name or keep the default name. To keep the default name, click enter Enter. Or click anywhere in the Macro Editor window with the mouse.

4.Enter the macro script.

New macros are saved automatically.

When you add a macro command to a file, the clip0001 Macros button appears on the Sidebar. Click this button to open the macro commands pane where you can perform the following actions:

Find a macro

Run a macro

Open the Macro Editor window

To close the macro commands pane, click the clip0002 button above the find and replace pane, or click clip0003 Macros on the Sidebar again.

The clip0004 Macros button is displayed in the Sidebar as long as the document contains at least one macro command.

Find a macro

If a file has multiple macro commands, find the macro that you need by following these steps:

1.On the Sidebar, click clip0001 Macros.

2.In the find and replace pane of the macro commands pane, specify the name of the macro that you want to find, in full or in part.

The list of macro commands will display macro commands with names matching the search request.

Run a macro

You can execute a macro command using the Macro Editor window or the macro commands operation pane.

To run a macro command using the Macro Editor window, follow these steps:

To run a macro, do the following:

1.In the Command menu, click Tools > Macro Editor.

2.In the Macro Editor window that appears, select the macro from the list.

3.Click Run.

The results are displayed in the Output pane.

To run a macro using the macros pane, do the following:

1.On the Sidebar, click the clip0001 Macros button.

2.Execute the macro in one of the following ways:

In the macro commands pane, hover the mouse cursor over the macro command name and click clip0005 Run.

Select the macro line by double-clicking it.

 

Edit a macro

1.Open the Macro Editor widow in one of the following ways:

In the Command menu, click Tools > Macro Editor.

On the Sidebar, click the clip0006 Macros button. On the macros pane, place the cursor over the title of the macro that you want to edit and click clip0007 Edit.

2.In the Macro Editor window that appears, select the macro from the list.

3.Make the necessary changes to its script.

All changes made to the script are saved automatically.

Debug a macro

Before you start the macro debugger, set the debugger breakpoints in the macro text. To do this:

1.Open the Macro Editor widow in one of the following ways:

In the Command menu, click Tools > Macro Editor.

On the Sidebar, click the clip0008 Macros button. On the macros pane, place the cursor over the title of the macro that you want to edit and click clip0009 Edit.

2.In the Macro Editor window, select the desired macro from the list.

3.Set the first debugger breakpoint. To do this, click to the right of the line number where you want to create a breakpoint. The breakpoint will be marked with the macros_breakpoint icon.

4.Set other breakpoints by repeating these actions.

To delete a breakpoint, click it with the mouse.

To debug a macro:

1.Click macros_debug Debug. The macro debugging process will begin. If the text of a macro contains breakpoints, the debugging process will stop on the line that contains the first breakpoint. If there are no breakpoints, the debugging process will stop at the first line of the macro.

2.To manage the debugging steps, use the following buttons:

macros_step_into Step Into: Perform one debugging step or step into the body of the function, if there is one in the current debugging position.

macros_step_over Step Over: Perform one debugging step without stepping into the body of the function.

macros_step_out Step Out: Continue executing the macro until leaving the function where the debugger is at the current position.

While debugging, the Macros Editor window displays the following areas:

In progress: This window will display messages while debugging.

Calls Stack: The calls stack window.

Variables: This window displays the values of local and global variables available at the current macro step. If the displayed variable is a table or an array, you can view its detailed contents by clicking the macros_variable button to the left of the variable name.

The debugging process ends once the end of the macro has been reached.

To interrupt the debugging process, click macros_stop Break script.

Delete a macro

To delete a macro:

1.Open the Macro Editor widow in one of the following ways:

In the Command menu, click Tools > Macro Editor.

On the Sidebar, click clip0010 Macros. On the macros pane, place the cursor over the title of the macro that you want to edit and click clip0011 Edit.

2.In the Macro Editor window that appears, select the macro from the list.

3.Click macros_delete_script_icon.

4.In the window that appears, confirm that you want to delete the macro.

View VBA macro code

In MyOffice Text, running VBA macros created in Microsoft Word is not possible. However, you can view the code of the VBA macros contained in the document and rewrite them in Lua.

VBA macros saved in the current Microsoft Word document are available for viewing.

To view and rewrite the VBA macro code, follow these steps:

1.Open the .docm file.

2.Select the Lua macro with the name of the VBA module that contains the desired VBA macro. For example, if Macro1 VBA macro is in Module1 VBA module, select Module1 Lua macro. Do one of the following to select the Lua macro:

In the Command menu, select Tools > Macro Editor. On the Macro Editor window, select the desired Lua macro.

On the Sidebar, click the side_panel_macro Macros button. On the macro pane, hover the mouse over the name of the desired Lua macro and click the side_panel_macro_edit Edit button.

The Macro Editor window will display the code of VBA macros that are contained in the corresponding VBA module.

3.Rewrite the code of the required VBA macro in Lua.

4.Close the Macro Editor window.

5.Save the document in .docx format using the Save as command.

The changes made are not saved in the original .docm file.

Was this helpful?
Yes
No
Next
Extensions