How to start an Excel macro at a certain time

[ocb]

Wish to make a Macro in Excel that copies cells fram one sheet to another every day at 17:00 without pressing any buttons. An automatic thing in other words that happens when Excel is started, withoung having to press any buttons.

Any ideas someone?

 

[nice95gle]

Look at the OnTime function

 

[ocb]

Can not find any OnTime function in Excel Functions - show all functions. Is this an internal VB-function? Can You tell me how and where it is used?

 

[AnotherHiggins]

Here are some easy to follow instructions.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[nice95gle]

I'm sorry ocb...it's a Method, but I believe that anotherhiggins example will get you started.

 

[Tigerlili3]

You can also schedule it through Windows Task Scheduler using a bat file and a reference to the macro. If you have windows task scheduler it will be located under Start | Programs | Accessories | System Tools | Scheduled Tasks. I can post more info about this if you're interested.