[RESOLVED] FileSystemWatcher For VBA??????

Is it possible to implement some sort of FileSystemWatcher in VBA? I am currently using a polling method that is quite hungry on resources. Any pointers to a better method would be greatly appreciated.

Thanks
maxduck

Welcome to the Forums.

You can use API code to set up a change notification but it is modal so not sure if it will work if you have other code. You may beed to create a separate process for this but whatr about just reducing the poll interval?

http://www.allapi.net/apilist/FindFi...fication.shtml

Thanks for that, I was affraid a separate process may be required. Your suggestion to increase the poll time is the easiest.

Thanks again