There is no command line option in excel that will allow you to do this but
you shouldn't need to. How are you creating the new workbooks? I assume
you will do it programmatically from another workbook that you're working
from? If so then you can do whatever you need to do to this newly created
file from that workbook; even have it write the module to your new file.
Would probably need some more information on what you are trying to do so if
you can explain in more detail then I may have some example code to help you.

"Al Franz" wrote:

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?