Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Batch file in Shell Function
I am trying to get a batch file to run in the background
of excel that transfers text files via ftp up and down from an AS400 server. I can get excel to call the batch file with the code Shell "C:\schedule\down.bat, 1", however, the batch file never completes its task and excel gives no error. I can run the batch file by going to the folder where it is stored and manually double clicking on the file. It runs in a DOS window and works fine when executed that way. Am I missing something in excel that allows the batch file to run in a DOS window or something? Can anyone help me with this problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Batch file in Shell Function
"Eric" wrote in message ... I am trying to get a batch file to run in the background of excel that transfers text files via ftp up and down from an AS400 server. I can get excel to call the batch file with the code Shell "C:\schedule\down.bat, 1", however, the batch file never completes its task and excel gives no error. I can run the batch file by going to the folder where it is stored and manually double clicking on the file. It runs in a DOS window and works fine when executed that way. Am I missing something in excel that allows the batch file to run in a DOS window or something? Can anyone help me with this problem? If you have VB, C++ or the Developer edition of office you can use the msinet.ocx in your VBA code to do the ftp avoiding the batch file altogether see http://officerone.tripod.com/vba/ftp_upload_file.html Keith |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Batch file in Shell Function
Hi Eric,
Try Shell "C:\schedule\down.bat", 1 instead. -- John johnf202 at hotmail dot com "Eric" wrote in message ... I am trying to get a batch file to run in the background of excel that transfers text files via ftp up and down from an AS400 server. I can get excel to call the batch file with the code Shell "C:\schedule\down.bat, 1", however, the batch file never completes its task and excel gives no error. I can run the batch file by going to the folder where it is stored and manually double clicking on the file. It runs in a DOS window and works fine when executed that way. Am I missing something in excel that allows the batch file to run in a DOS window or something? Can anyone help me with this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run batch job from each row - how to insert run batch function per row? | Excel Discussion (Misc queries) | |||
Shell function II | Excel Programming | |||
Shell function II | Excel Programming | |||
Shell function | Excel Programming | |||
Copying a file with VBA (or with a SHELL command) | Excel Programming |