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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event for a file being changed?
If by "change" you mean a manual or remote entry, use the
Workbook_SheetChange() event. Otherwise, what do you expect to be changing? In article , R Avery wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event for a file being changed?
Sorry, I was not clear. I meant how do I get an event when an un-opened
text file is changed? |
Reply |
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 |