Post a reply :: Support Forum

Tip: Styles can be applied quickly to selected text.

Options
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)

Options

Topic review

stephenchristian

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
Winscp.com /script=upload.txt

The script file works correctly:
open upload
synchronize remote
exit

I am aiming for something like this:
Do
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