I need to write a program that will loop through a series of date directories and pass in the folder name to a batch file, let the batch file run and then loop to the next directory.
For Each ProcessDate In clb_ProcessDates.CheckedItems
Call Shell("Run.bat" & " " & ProcessDate.ToString)
The probblem is I need to wait til the Run.bat (Batch File) has completed until I move on to the next process date.
How can I determine when the batch file has completed and move to the next date?