Wait for shell command to complete

Advertisement

daywindows
Joined:
Posts:
4
Location:
Canada

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?

Reply with quote

Advertisement

daywindows
Joined:
Posts:
4
Location:
Canada

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)

Reply with quote

martin
Site Admin
martin avatar

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.

Reply with quote

Advertisement

You can post new topics in this forum