Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why is absolute hyperlink in XLS file changed when file is saved | Excel Discussion (Misc queries) | |||
in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
I had template that when you changed date of the event, it automa. | Excel Worksheet Functions | |||
Excel is not asking to save a changed file when the file is closed | Excel Discussion (Misc queries) | |||
worksheet_change event when multiple cells changed (pasted) | Excel Programming |