Is there any way to run a macro from the command line while opening excel?
ie: c:\xxxxxxxx.xls "macroname"
?

if not, basically I am trying to write a program that reads all of the files in a directory, and for all of the excel files, it opens them, runs a specific macro on them, and then saves and closes them.

Does anyone have any ideas?