Event for a file being changed?

  • Thread starter Thread starter R Avery
  • Start date Start date
R

R Avery

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?
 
If by "change" you mean a manual or remote entry, use the
Workbook_SheetChange() event.

Otherwise, what do you expect to be changing?
 
Sorry, I was not clear. I meant how do I get an event when an un-opened
text file is changed?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet Change Event (Insert Row) 2
Passing data to an event handler 3
Include Dropdowns and Checkboxes in Worksheet Change event 1
Event when cursor changes cells, but no select(?) 2
Excel Add-In to catch application events 1
Cell value change event 1
Monitor Changes in a folder 1
Excel Got FOcus event 2

Back
Top