Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell and Command Prompt Question
I am shelling to the Command Prompt and executing an FTP connection with
switches like this: x = Shell("ftp -i -s:ftp_input_script ftp_server_namek) The ftp_input_script fetches a file from the ftp server, then exits. The last command in the ftp_input_script is "bye". My problem is that Excel seems to kill the ftp session before a proper "bye" is completed, even when I put wait routines after shelling. Is there a way to send a "bye" command to the FTP session from Excel? I'm thinking that I can keep the FTP sessoin open, verify that the file downloaded correctly, and then kill the ftp session. Fred*** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell and Command Prompt Question
Hi Fred,
It's not that Excel is killing the ftp session, it just continues running code without waiting for the end of the shell command. At a place I used to work at, we got around this by separating the macro so that the first macro ends with the shell function and the second macro doesn't start until it successfully checks for a condition that the shell function is complete. HTH, Greg "Fred***" wrote in message ... I am shelling to the Command Prompt and executing an FTP connection with switches like this: x = Shell("ftp -i -s:ftp_input_script ftp_server_namek) The ftp_input_script fetches a file from the ftp server, then exits. The last command in the ftp_input_script is "bye". My problem is that Excel seems to kill the ftp session before a proper "bye" is completed, even when I put wait routines after shelling. Is there a way to send a "bye" command to the FTP session from Excel? I'm thinking that I can keep the FTP sessoin open, verify that the file downloaded correctly, and then kill the ftp session. Fred*** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell and Command Prompt Question
And if you want your code to wait for the FTP to finish...
http://support.microsoft.com/?kbid=214248 XL2000: How to Force Macro Code to Wait for Outside Procedure Here's a link to a nice ShellAndWait function that does that. http://groups.google.com/groups?thre...%40tkmsftngp03 Fred*** wrote: I am shelling to the Command Prompt and executing an FTP connection with switches like this: x = Shell("ftp -i -s:ftp_input_script ftp_server_namek) The ftp_input_script fetches a file from the ftp server, then exits. The last command in the ftp_input_script is "bye". My problem is that Excel seems to kill the ftp session before a proper "bye" is completed, even when I put wait routines after shelling. Is there a way to send a "bye" command to the FTP session from Excel? I'm thinking that I can keep the FTP sessoin open, verify that the file downloaded correctly, and then kill the ftp session. Fred*** -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shell command | Excel Programming | |||
Commands at the line prompt using Shell | Excel Programming | |||
xp shell command using vba | Excel Programming | |||
SHELL command | Excel Programming | |||
Copying a file with VBA (or with a SHELL command) | Excel Programming |