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?


--
DrukeEr
------------------------------------------------------------------------
DrukeEr's Profile: http://www.excelforum.com/member.php...o&userid=25575
View this thread: http://www.excelforum.com/showthread...hreadid=390020