How to start a Macro automatically at a scheduled time?

[DayTraderKevin]

Is there a way to start a macro automatically at a scheduled time, at 06:30?

I'm already using myTimer to run the VBA script every minute: myTimer = Now + TimeValue("00:01:00")

 

[James006]

How to automatically start Macro at a set time?

I found this somewhere online and placed it in ThisWorkbook... Private Sub Workbook_Open() Runs a macro at 6:30 AM Application.OnTime TimeValue("18:20:01"), "GetMyData" End Sub It sort of works. My macro is programmed to run every minute... myTimer = Now + TimeValue("00:01:00") When I run...

www.mrexcel.com

 

[DayTraderKevin]

How to automatically start Macro at a set time?

I found this somewhere online and placed it in ThisWorkbook... Private Sub Workbook_Open() Runs a macro at 6:30 AM Application.OnTime TimeValue("18:20:01"), "GetMyData" End Sub It sort of works. My macro is programmed to run every minute... myTimer = Now + TimeValue("00:01:00") When I run...

www.mrexcel.com

Ha, ha! That's my post. Nobody responded so I'm trying again.