Open Batch File For Processing

I want to open BATCH.bat in a macro.
I tried 'ReturnVal = Shell("C:\BATCH.bat", 1)' and it opens a DOS window and runs through about 20 different command lines very quickly without executing any of them.

HELP.

You have another reply at your other thread.

Chuckles123 wrote:
>
> I want to open BATCH.bat in a macro.
> I tried 'ReturnVal = Shell("C:\BATCH.bat", 1)' and it opens a DOS
> window and runs through about 20 different command lines very quickly
> without executing any of them.
>
> HELP.
>
> --
> Chuckles123
> ------------------------------------------------------------------------
> Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
> View this thread: http://www.excelforum.com/showthread...hreadid=385662

--

Dave Peterson

I have two files file1.xls & file2.xls. I first open file1.xls, subsequently
through VBA code in file1.xls, I need to open file2.xls and execute an macro
in file2.xls. Do anybody have suggestions?

I am able to open file2.xls through this command, but unable to execute any
macro in that.
Workbooks.Open Filename:=

Thanks
Mahendhra

Hi Mahendra,

Try:

Application.Run ("File2.xls!YourMacroName")


---
Regards,
Norman



"Mahendhra" <[email protected]> wrote in message
news:[email protected]...
>I have two files file1.xls & file2.xls. I first open file1.xls,
>subsequently
> through VBA code in file1.xls, I need to open file2.xls and execute an
> macro
> in file2.xls. Do anybody have suggestions?
>
> I am able to open file2.xls through this command, but unable to execute
> any
> macro in that.
> Workbooks.Open Filename:=
>
> Thanks
> Mahendhra

Thanks!! It is working for me now.

"Norman Jones" wrote:

> Hi Mahendra,
>
> Try:
>
> Application.Run ("File2.xls!YourMacroName")
>
>
> ---
> Regards,
> Norman
>
>
>
> "Mahendhra" <[email protected]> wrote in message
> news:[email protected]...
> >I have two files file1.xls & file2.xls. I first open file1.xls,
> >subsequently
> > through VBA code in file1.xls, I need to open file2.xls and execute an
> > macro
> > in file2.xls. Do anybody have suggestions?
> >
> > I am able to open file2.xls through this command, but unable to execute
> > any
> > macro in that.
> > Workbooks.Open Filename:=
> >
> > Thanks
> > Mahendhra
>
>
>