Timer needed

[manofsteel00]

Any ideas on how to make a function wait on another function before it begins? I have a function that runs a batch file; the file takes around 5 minutes to run. The next function has to apply a filter on the resulting text file of the batch file. The filter applies too soon and sees that there is nothing to apply the filter to so the program ends. Here's some code:

Private Sub runBatch()
     Shell ("INVENTORY_FTP.bat")
     'Need to wait 5 minutes here
End Sub

[randem]

Why not just do a shellandwait until the batch file is done? You can do a search in the forum for that.

[dglienna]

Or, you could use this:

Shell ("Start /wait INVENTORY_FTP.bat")

which will wait until the batch file finishes.
you might need a cmd in there

[manofsteel00]

dglienna: It says File Not Found

[dglienna]

Not sure if it's the command, or that you don't have the path to the batch file.
Try adding the path to the batch file, and if that doesn't work, then this should

Shell ("C:\Windows\System32\cmd.exe /c  " & _
     "Start /wait INVENTORY_FTP.bat"), vbNormalFocus

[manofsteel00]

Actually I was wondering if shellandwait would work, but my program doesn't recognize the shellandwait command

[dglienna]

There is no command. It combines the same API's that start does.

http://vbforums.com/attachment.php?attachmentid=41200

Here is an example of shell and wait, though.

[manofsteel00]

That was a little too complex for me to understand.

[manofsteel00]

I've seen some other people using the shellandwait command in VB6. Is there something I need to add before my program recognizes that command?

Here's one of those threads:
http://www.vbforums.com/showthread.php?t=373660

[dglienna]

I posted what everybody was using. That's why I suggested Start /Wait. It's a lot simpler.

[manofsteel00]

True, let me try that again

[manofsteel00]

This code works:

Shell ("C:\Windows\System32\cmd.exe /c  " & _
     "Start /wait INVENTORY_FTP.bat"), vbNormalFocus

However, it opens two command windows. And doesn't close them.

But this code doesn't:

Shell ("Start /wait INVENTORY_FTP.bat"), vbNormalFocus

I'd like to have only one command window open and the window close after running the command

[dglienna]

Use the /B flag. Try start /? from a command prompt.

start /wait /b myfile.bat

and take off the last command to show focus. that was only for testing.

[manofsteel00]

Anyone know how to get around the fact that the file path contains a space when trying to run a batch file? It says "File NOT FOUND: G:\Finance\Inventory" If anyone can help me out I'd be most appreciative. Thanks. As always here's the code:

Shell ("Start /wait /b G:\Finance\Inventory Control\CycleCount\DB\deleteCycleCount.bat")

[randem]

Put your path and filename in quotes.

Shell ("Start /wait /b " & chr(34) & "G:\Finance\Inventory Control\CycleCount\DB\deleteCycleCount.bat" & chr(34))