Thread: Run Excel Macro
View Single Post
  #2 (permalink)  
Old 06-19-2009, 01:02 PM
forumsupport forumsupport is offline
Senior Member
 
Join Date: Apr 2007
Posts: 1,342
Post

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.
Reply With Quote