Automatic startup of an excel macro

  • Thread starter Thread starter Quist
  • Start date Start date
Q

Quist

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
 
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,

In the 'Workbook Open' event, put the macro name, like this:

Private Sub Workbook_Open()
MyMacro
End Sub

You will find this in the Excel Visual Basic Editors 'VBAProject'
window. Double click on 'ThisWorkBook' and select 'WorkBook' from the
drop down list.
 
Thanx for the quick replies!
The drawback with the suggested methods is that I can't open the
document without running the macro.
In a perfect world I would like the scheduler to uppdate the data in my
document once a day and then I (and others) would be able to open it
for wieving data without updating it.
 
Back
Top