Quist

look at the VBA Help for the OnTime Method. And search the Google Archives
for OnTime ... you should find lots of examples.

Regards

Trevor


"Quist" wrote in message
...
I have an Excel macro that I want to be run at a specific time each day.
I have therefore added the Excel Workbook to the Windows scheduler
which opens it at the correct time.
The only thing that is missing now is an automatic way to run the macro
once the workbook has been opened. The optimal solution, as I see it,
would be to trigger the macro from the scheduler call with some kind of
switch but I can't find any information about such switches. I have
fond information on how to do it in Access but this doesn't seem to
work in Excel.

"C:\Program_Files\Office\Msaccess.exe" "C:\Files\accessfile.mdb" /x
Macro_name

The switch /x should do the job and call the macro when the document
has been opened but as mentioned above I can't get it work in excel.

Does anyone have any suggestions on other switches or other ways to
solve my problem?

Best regards



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/