Hello once again everyone..
I'm wondering if I can use Excel to monitor for an external file update (timestamp change) and when the monitored file (.CSV) changes, extract various bits of data from it (and update the current .XLS file) and then go back to waiting again..
I would like to use some sort of "non-blocking" wait function so that I check for file updates only so often (so my CPU load doesn't go to 100%) and can click a button on the form to disable the loop (though a global "LoopEnabled" boolean variable, for instance), and of course to give Excel time to perform it's screen updates to see the new data.. I see the "Application.Wait()" function is available, but it blocks everything, including my ability to click a "stop" button on the worksheet.. [img]/forums/images/smilies/sad.gif[/img]
I know this isn't exactly what Excel is tailored for, but the data I wish to monitor for is Excel data and this sure would be a simple approach..
thanks in advance,