Microsoft Office Tutorials and References
In Depth Information
Executing a saved import/export
Executing a saved import/export
Macro commands are provided for running the saved import/
export processes that we described in Section 11, “Exchang-
ing data,” starting on page 201. For example, on a form, these
commands could allow you to create a button that executes a
sequence of import/export processes to manage your data.
In this example we will show how to create a macro that is not
embedded inside a form. You can then execute this macro from
the navigation pane, or alternatively, you could use the RunMacro
command inside an embedded macro on a button on a form.
(Macros can run other macros.)
Execute a saved import/export
1 Click the Create tab.
2 Click Macro.
3 Click Show All Actions.
4 Select the RunSavedImportExport action. (You will need to have
already saved an import/export to use this.) Select the file to import
or export.
5 Click Save.
6 Type a name for the macro, and click OK. In the navigation pane, a
new object type will be shown (unless you have previously created
macros). Double-click the macro to execute the operation.
1
2
5 4
3
6
To edit your macro, display the macro in the navigation pane,
rightclick, and select Design View.
7
TIP You will notice when executing this macro that there is
not a message indicating that the macro has executed. As a final
step, you could add a message box to indicate that the macro has
completed the export.
7
Search JabSto ::




Custom Search