Run Macro from Command line

P

Phil Smith

I want to run a macro when I open a particular spreadsheet. I know I
can get a macro to run every single time it opens, but I do not want
that. I want to start Excel externally, (from a shortcut) and either
load it and run the macro, or load it and not run the macro.

I do not see any option to open and run a macro from the command line.

Does it exist? Is there another way to pull this off?

Phil
 
D

David McRitchie

You could put data into a text file and read that from
your VBA code. You could use a .bat file to create/modify
the file.
 
Top