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