StopMacroRecording Method (Macro)

In This Topic

Stops the macro recorder in the current terminal session, and saves the macro.

Syntax

expression.StopMacroRecording( _
   ByVal saveLocation As MacroDestinationOption, _
   ByVal macroName As String _
)

where expression is a variable that represents a Macro Object

saveLocation: The location to which the macro is saved. MacroDestinationOption.Document saves to the session document's VBA project. MacroDestinationOption.CommonProject saves to the Common VBA project. MacroDestinationOption.Clipboard copies the macro script to the Windows Clipboard.
macroName: The name of the saved macro. This parameter is ignored if saveLocation is Clipboard.

Exceptions

Exception	Description
ArgumentException	Thrown if the macro name is null, empty, or contains invalid characters.

Send Feedback