Run Excel Macro through Batch file

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>

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.

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)


"LJi" <[email protected]> wrote in message
news:[email protected]...
> 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.
>