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? |
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 |