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 DO
window and runs through about 20 different command lines very quickl
without executing any of them.

HELP

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=38566

Open Batch File For Processing
 

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

Batch
 

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

Batch
 

Hi Mahendra,

Try:

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


---
Regards,
Norman



"Mahendhra" wrote in message
...
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

Batch
 

Thanks!! It is working for me now.

"Norman Jones" wrote:

Hi Mahendra,

Try:

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


---
Regards,
Norman



"Mahendhra" wrote in message
...
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