Can you use automation to run the macro? You can create a script file
to do this and run it from the command line....

Others may have more suggestions if you can outline what it is you're
doing.

Tim.


"Al Franz" wrote in message
...
Is there a way to run an Excel macro from a command line. Such as
when you open up a file to have it run the macro. Since I want to
do this for files that are newly created I can not program the file
to run the macro at startup. Is there a command line option in
excel?