#1
|
|||
|
|||
vb code for updating file automatically
Hi all, I have code for showing file details in a folder, for instance, the folder name, the file name, revision with its last date modified details. Yet, I would like to update the list automatically when the user removes a file from the folder, adds a file in the folder as well as modifies a file in the folder. May I know how can I achieve this? Can anyone help? Please see attached my code. Thanks in advance. |
#2
|
||||
|
||||
Excel doesn't have event-driven capabilities for folder monitoring. What you could do, however, is change the name of your PrintFolders macro to Auto_Open, so it runs automatically every time the workbook is opened.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
vba code |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Captions automatically updating all previous entries | jhats | Word | 1 | 07-29-2014 11:53 PM |
Help with set up of automatically updating cross reference. | lukebrown | Word VBA | 5 | 09-11-2013 09:38 AM |
Word 2010 Includetext not automatically updating | nataliec | Word | 4 | 12-13-2012 02:37 PM |
Automatically Updating Content in Text | dumbass0101 | Word | 4 | 10-11-2012 07:50 AM |
Automatically updating currency exchange rate? | Metamag | Excel | 2 | 09-07-2012 09:00 PM |