Run macro on time schedule

[incobart]

Hi,

I could find how to run a macro on a time interval, for example every 15 min.
he first do with a workbook.open script, and then I add it in the script,

Please Login or Register  to view this content.

he does my workbook.open run, he does it after 15 min, but then the next time he make a runtime error 9, out of range, on this line : Sheets("collector").Select

I had ro put it otherwise the macro run on another active sheet

anyone know how to solve this ?

Thanks
Chris

[Logit]

.
.
Make certain the sheet name is correctly entered in the macro code :

Please Login or Register  to view this content.

or is it spelled:

Please Login or Register  to view this content.

????

There is a mistake of some kind in the Sheet name.

[incobart]

The macro run already many days, yesterday I put the time scheduler and it crash at the second 15 min,

I can still run manualy even with the timer ..

[Logit]

I ran your macro here but changed the Sheet name. No problems.

Must be something else going on with another part of your project ?

Can you post the workbook for review ?

[incobart]

hi, suddely it did it, I don't know how it come, but it works now, thanks for your help