Executing a .BAT file using excel macro

V

Vasanth

HI

I have a .bat file which downloads a Mainframe file into a text fil
through FTP into my local machine.I need to execute this .bat fil
through excel vba. I tried the below shell script commands.

sYourCommand = "C:\Documents and Settings\FTP\mtc\extract.bat"
x = Shell("cmd.exe /c " & sYourCommand, 1)

The command window opens but the file is not downloaded.

when i execute the .bat file manually i get the files downloaded. Pleas
help me to excute this .bat file throough excel vba.


Below details may help

the .bat file command ---------- ftp -s:file1.txt 192.74.252.153
file1.txt ( in the same location as .bat file )contains the use
credentials and mainframe and local file name details.
as below

k9999
tda1234
get 'PJJJ.NVS.PJJJDSLA.SLARRRD.JJJ(0)' sla.tx
 
J

James Ravenswood

HI

I have a .bat file which downloads a Mainframe file into a text file
through FTP into my local machine.I need to execute this .bat file
through excel vba. I tried the below shell script commands.

sYourCommand = "C:\Documents and Settings\FTP\mtc\extract.bat"
x = Shell("cmd.exe /c " & sYourCommand, 1)

The command window opens but the file is not downloaded.

when i execute the .bat file manually i get the files downloaded. Please
help me to excute this .bat file throough excel vba.


Below details may help

the .bat file command ---------- ftp -s:file1.txt 192.74.252.153
file1.txt ( in the same location as .bat file )contains the user
credentials and mainframe and local file name details.
as below

k9999
tda1234
get 'PJJJ.NVS.PJJJDSLA.SLARRRD.JJJ(0)' sla.txt

Consider putting a
pause
at the end of the bat file

That way you can see what is going on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top