Run Macro from Command line

  • Thread starter Thread starter Phil Smith
  • Start date Start date
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
 
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.
 
Back
Top