Post a reply

Before posting, please read how to report bug or request support effectively.

Bug reports without an attached log file are usually useless.

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

martin

Re: Wait for shell command to complete

Do you have any reason to believe that the code won't work in Access? I'm quite sure it will work.
daywindows

Re: Wait for shell command to complete

The solution suggested seems to be for MS Excel VBA.
I am looking for a solution for MS Access VBA.
Below is the shell call that I use.
I cannot see where the shellandwait function integrates with this.
Call Shell(strSFTPDir & "winscp.com " & strQuote & strCommand & strQuote, vbHide)
daywindows

Wait for shell command to complete

Does anyone know of VBA code that waits for the WinSCP shell command to finish executing before proceeding to run vba code after the shell?