Constantly Running Macro

Re: Constantly Running Macro

Quote from AndrewJ

Well, if the code is in the master file, theres no way to trigger it without some event from the user workbooks, or by periodically testing the folder the user books are saved in.

There are application level events , like the saving of any workbook, that will trigger an application level event which will trigger a routine residing in only one of the workbooks.

Re: Constantly Running Macro

I notice that this

.DateLastModified > TimeSerial(Now, -5, 0)

should change to

.DateLastModified > now - timevalue("0:05")

Re: Constantly Running Macro

Quote from mikerickson

There are application level events , like the saving of any workbook, that will trigger an application level event which will trigger a routine residing in only one of the workbooks.

But will that work across a network? I thought application level events were restricted to the application on the specific machine.

Re: Constantly Running Macro

Probably on the specific machine. I could see a local network set up so that it would work. The IT people should be consulted, a similar scenario might be possible. It wouldn't suprise me if there were network wide events that IT uses to monitor things.

Re: Constantly Running Macro

This sought of task is better suited to scripting.........

See here for an idea on how to do this............

http://www.dailydoseofexcel.co…/07/07/monitor-directory/