Excel 2007 Application.ontime

[kennedymr2]

I need to have 2 timers running in Excel 2007

I have one timer working fine... it does a function every
2 minutes.

I also need to test if a files content has changed, say every 1 second. ie open a file for input, read the 1st line and then close. If the data is different run a function.

???can i have more than 1 application.ontime

or do i have to have say a public variable that triggers the 2 minute function every time it gets to 120.

??if i use the windows timer, i guess it would trip up on the application.ontime..??? i would rather not use this

Appreciate any ideas

Kennedymr2

 

[SkipVought]

Hi,

Please post VBA questions in Forum707.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[kennedymr2]

Thanks... Have reposted to Vba... was not sure where to put this Question !!!!