Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic startup of an excel macro
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic startup of an excel macro
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic startup of an excel macro
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. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic startup of an excel macro
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. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Startup for a Macro | Excel Discussion (Misc queries) | |||
Startup Macro | Excel Discussion (Misc queries) | |||
starting a macro at startup | Excel Discussion (Misc queries) | |||
Startup macro | Excel Discussion (Misc queries) | |||
Run a Macro on Startup for Specific Spreadsheet | Excel Worksheet Functions |