You can record a VBA macro to automate your interaction with host applications, including:
Sending data to, or typing text in, a host application.
Cutting, copying, or pasting text or data from one host application to another.
Switching tabs to move from one host application to another.
Selecting text with a mouse or clicking the mouse to move the cursor (mouse clicks are recorded as cursor positions.)
You cannot record:
Interaction with Reflection settings and Productivity features (such as Spell Check, Auto Expand, and Auto Complete).
Connecting to or disconnecting from a host.
Interaction with Web applications.
Cutting or pasting from a host to an external application (for example, Notepad).
To record a macro
The steps depend on your user interface mode.
|
User Interface Mode |
Steps |
|---|---|
|
Ribbon |
On the Macrostab, from the Advancedgroup, clickRecord VBA. |
|
Reflection Browser |
On the Reflection menu, choose Tools, Macroand then Record VBA Macro. |
|
TouchUx |
Tap the Wrench icon, and then under Macro, select Record VBA Macro. |
Perform the task(s) that you want to automate.
(Optional) If you need to interrupt the recording to perform another task, click Pause Recording. When you are ready to resume recording, click Pause Recordingagain.
When you are finished recording the macro, click Stop Recording.
The Recording Complete dialog box appears.
Name the macro, choose the location where you want to save it, and then click OK.
NOTE:You can fine-tune recorded macros by using the Visual Basic Editor. For more information, see see Edit a Macro.