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

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


    should change to

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

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!