Post a reply

Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)


Topic review


VBA(Excel) .bat check back, pause/resume

Dear WinSCP.

I would like to know how to do a .bat check back to see if the file transfer completed correctly and pause vba until the transfer has completed.

The details are:

Windows Vista sp2,Office enterprise 2007

Version: 5.1.4(2020),Protocol: FTP,Encryption: TLS Explicit enc.

The .bat file works correctly:
cd C:\Program Files\WinSCP /script=upload.txt

The script file works correctly:
open upload
synchronize remote

I am aiming for something like this:
checkback = false
Shell "C:\Users\******\******\*****\homepageupload.bat"
(I need a check back and to be able to pause VBA(excel) while the script is running)
Loop until checkback = true

Many thanks