automated Macro update

[Spockster]

I have asked this question before and had no response so I thought i would post again.
We are on a Citrix network and have reports that are pulled everyday. The problem is on the weekend no one is here to input the data so what i was thinking was to have a macro that could autorun on the weekend period.
Is this possible and if so how is it done.

Thanks,

 

[Legacy 98055]

Hey Spock.
Big question with so little details. Chances are, "Yes!"
If anything, you could use the Task Scheduler to run your code at anytime you wish. I use it all the time for various apps. Post some more details if you need some more details yourself.

Tom

 

[Spockster]

Hey thanks for the idea but with the citrix network we don't have the task scheduler.
I just want to know if there is code to add to the macro so that it will run at a certain time everyday

Thanks

 

[Legacy 98055]

Yeah.
But the workbook would need to be open all day.
See the "OnTime" method in VBA help.
Also, Chip Pierson has some good info on using the OnTime methos on hiw website.
Tom