Run Excel Macro

[MBorn]

Hello,

when I start an Excel-spreadsheet with Open Spreadsheet and then run
Excel-Macro, the Macro (with the Default Session) will run without
a problem.

When I leave the spreadsheet open and want to start the same
Task WITHOUT opening the spreadsheet, (so: ONLY run the Macro,
because the spreadsheet is already open) I get the message
"Cannot find any open spreadsheet command using session
name "Default".

How do you handle this ?

Thank you,

Born

[forumsupport]

Hello Born,

When you use the ‘Open-Spreadsheet’ command, it starts a session named ‘Default’ and that will continue to run unless you ended the session using the ‘Close Spreadsheet’ command or close the spreadsheet manually. All the commands between ‘Open-Spreadsheet’ and Close Spreadsheet’ are dependant on the session which is started using the ‘Open Spreadsheet’ command. If you wish to work with many separate excel spreadsheets, specify a different session name while opening the each spreadsheet.

If you wish to run excel macro in an already open spreasheet then assign a shortcut key to that macro and play that shortcut key using 'Insert Keystrokes' command.

Hope that helps.