View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R Avery R Avery is offline
external usenet poster
 
Posts: 220
Default Event for a file being changed?

Is there anyway to code an event for a file being changed (or accessed)
in VBA? What I have been doing is setting Excel to read a file every
few seconds to see if it changes, and if it does, take an action.
However, as the time interval between checks shrinks, Excel becomes
increasingly unresponsive and unruly.

However, if there were simply an event that i could trap like
OnFileChanged, then that would keep the Excel UI responsive. Is this
possible?