VBA Wait - Proceed once File is in Folder (Solved)

Hello!

-Using a mixture of vBscript + VBA-

The vBscript runs a report and generates an excel file & places it into a folder on my computer. I am using VBA to initiate this process, the problem is VBA does not wait for the vBscript to finish generating this excel file & moves on to the next lines of code which causes errors.

Currently am using Application.Wait Now + Timevalue ("00:00:30") to wait 30 seconds which is working....but next month maybe the reports might need more time.

How can I make my VBA code smarter? Is it possible for VBA to wait until a file is in a specific folder with a specific name before continuing onto the next lines of code instead of waiting for a set time (30 seconds for example)?

Thank you huuthang_bd for pointing me in a direction. Need to refresh myself on looping and will implement.

'idea that comes to mind is to "Loop until. Check a specific folder with a specific excel file name to show. Loop this check until the file appears. Once it does, end loop and proceed with code.

- Edit will respond better later today to explain low on time so typed that out fast -- The event seems like a very good idea that I will look into today.

Good points. I went with your idea of having vBscript editing a cell in excel once finished and having the next lines of vba/vbscript activate. Works like a charm!

Solved!

Thanks!!!