Run 2nd sub procedure when the first is done successful

[grid]

Hello,

With VBA I load a batch script. Then I run a 2nd procedure in VBA. The 2nd procedure should only run if the batch script is closed.

Please Login or Register  to view this content.

I found the following somewhere on Google. I do not know if it has to do with what I want.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I get here a message: Object required


If anyone can help me I appreciate it.


Best regards,

grid

[grid]

Hello,

It has been resolved. I found out how it works. The solution is on this page:

http://www.scottandmichelle.net/scot...mv?codenum=069

I've adapted the script of the page. I have adapted these lines:

ShellAndWait "notepad", vbNormalFocus, True

To:

ShellAndWait "C:\temp.bat", vbNormalFocus, True

This line opens temp.bat (the batch script). Below is the next line. The next line is only executed if temp.bat closed.


Best regards,

grid