Hi All
I use a application called TheFolderSpy, this application simply watches a specific folder for any changes (new files created, files deleted, new folders etc).
Folderspy then opens a excel file which has a bunch of code to run on open, working with files/folders within the watched folder.
My issue is, that TheFolderSpy opens the excel file for every change detected, so for example if 3 files get copied into the watched folder, TheFolderSpy will open my excel file 3 times, and in quick succession, like a few seconds a part basically as quick as the files are actually copied in by windows.
What I need to do, hopefully through VBA, is somehow only run my code once per bulk files added/changed. So if 3 files are copied into the watched folder, and TheFolderSpy opens my file three times, I want to somehow capture this 3 times in the excel VBA and only actually run the code once.
But have it run again, if some more files are copied in say a few minutes later.
Any ideas? Is this possible?
I use a application called TheFolderSpy, this application simply watches a specific folder for any changes (new files created, files deleted, new folders etc).
Folderspy then opens a excel file which has a bunch of code to run on open, working with files/folders within the watched folder.
My issue is, that TheFolderSpy opens the excel file for every change detected, so for example if 3 files get copied into the watched folder, TheFolderSpy will open my excel file 3 times, and in quick succession, like a few seconds a part basically as quick as the files are actually copied in by windows.
What I need to do, hopefully through VBA, is somehow only run my code once per bulk files added/changed. So if 3 files are copied into the watched folder, and TheFolderSpy opens my file three times, I want to somehow capture this 3 times in the excel VBA and only actually run the code once.
But have it run again, if some more files are copied in say a few minutes later.
Any ideas? Is this possible?
Last edited:
