Monitor a Folder for the Creation of File (csv), then Load

[#1]

Hi all,

Is it possible to have a macro to pole a folder and when a csv file is added for it to be loaded into QV?

Any help on how to do this will be great!

[#2]

I have no objection to that  /adding more steps if fine

[#3 · Accepted solution]

I've managed to solve this problem..... pretty simple - I've added 2 as the bWaitOnReturn part of the WshShell.Run script (that executes my Python Script).

A text box will open once Python is finished (file would be there) & I now know when to reload the data.

Thanks for all the suggestions.