I have a batch file, FTP.Bat, in c:\Temp:
> Del zFTP.Txt
> winscp /script=zFTP.Scp /log=zFTP.Txt
> cscript c:\temp\test.vbs
> Exit
and Test.vbs contains MailBox("OK")
When I execute it either as a straight batch file, from the Start_Run line, or as a batch file thru the VBA Shell, I see the "OK" message from cscript.
But when I execute the batch file thru the VBA Shell Command
Call Shell("c:\Temp\FTP.Bat")
then neither the "Del" nor the "Winscp" lines get executed.
Any idea what's going on?
Mac, Berkeley, CA
Last edited by CaptMac; 11-18-2010 at 02:51 PM. Reason: Closing this.
To make this work thru VBA Shell, you have to be explicit about all file locations: ie., put complete Folder addresses on them.
Mac
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks