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

If you're writing in VB or VB.NET I would use OLE to open up the Excel
files and process them, with your code running in the application.

Would that help?

DrukeEr wrote:
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?

It would have, except I do not know how to use OL

--
DrukeE
-----------------------------------------------------------------------
DrukeEr's Profile: http://www.excelforum.com/member.php...fo&userid=2557
View this thread: http://www.excelforum.com/showthread.php?threadid=39002

If you give more details on what you're developing in and the scope I
can demonstrate code. OLE is easy - the same as developing on VB really
- if that's what you're doing.

DrukeEr wrote:
It would have, except I do not know how to use OLE