Run Excel Macro through Batch file

[LJi]

Hi List,

Is that possible to run an Excel macro through a batch file? If yes,
can I pass value to run a macro? For example, if i need to let the
macro work on centern files, can i pass the file name when calling the
macro from the batch file? Like

C:\testmacro.xls FileOne.xls

Thanks for any help.

 

[Bob Phillips]

You can schedule an Excel macro to run at a pre-defined time if that is any
good. You cannot run an Excel macro outside of Excel.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[LJi]

User already has a batch file which contains different command lines to
run different programs. they want to add this macro into it.

I may need to rewrite the macro using VB.

Thanks for your reply.

 

[Bob Phillips]

If it is a .bat file, would it be okay just to shell it?

--

HTH

RP
(remove nothere from the email address if mailing direct)