Storing the macro script
As with an ordinary macro, the Macro object creates the macro script for the recorded macro in the selected location.
As you switch between different active sessions during the recording process, the Macro object continues to store the recorded information into the same location that you originally selected.