how can I run a macro at a specified date or tim ?
for exampel i want to run macro each saturday at 7:00 AM.

I am a beginner myself, but maybe this helps you a bit further.

To run a macro at a certain time you can use the following:

application.ontime date + timeserial(7,0,0),"name of your macro"

this will make your macro run at this day on 7 pm.

If you want to run a macro next saterday you can do the following:

startdate=dateserial(2006, 5,20)
application.ontime startdate + timeserial(7,0,0),"name of your macro"

It is not neccesary to keep the sheet open, but excel should be running in the background to keep track of time.

Good luck,

Jeroen

i want to run this macro only one time on each saturday . for example if at 7:00 excel wasn't open the macro run at the first time the program be opend , and don't be run until next saturdey .
what should i do now ?

It is impossible to run a macro without opend excel!

I think you may open excel with VB6 and then you can execute your code.

But I can't help you with this problem because I'm not particularly good in VB6.

Ask a question in the VB forum I think someone will help you with your problem



I hope this is good english, because this tongue is not my native language.
Please improve me if my syntax is wrong.
Thanks

where should I write this cod :
'application.ontime date + timeserial(7,0,0),"name of your macro" ' , if i want excel to run my macro at this certain time . i mean if my file wasn't open (but excel was open)how dose excel run this macro for example at 7:00 ?