Monitor Changes in a folder
 

I work for a company that posts test data on irregular intervals to a folder
on our network. I have written several worksheets that process that data in
various ways. I have a dedicated computer that runs a loop and counts the
number of files in the folder, and then triggers the programs if that folder
count changes. This is, of course very inefficient, so my question is, is
there some folder event that Excel can monitor to trigger the running of
those macros?

Monitor Changes in a folder
 

You may want to look at Randy Birch's site:
http://vbnet.mvps.org/index.html?cod...chedfolder.htm



Marvin wrote:

I work for a company that posts test data on irregular intervals to a folder
on our network. I have written several worksheets that process that data in
various ways. I have a dedicated computer that runs a loop and counts the
number of files in the folder, and then triggers the programs if that folder
count changes. This is, of course very inefficient, so my question is, is
there some folder event that Excel can monitor to trigger the running of
those macros?

--

Dave Peterson