Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time of Day Update
I can not get the program to run. I have the OnTime just
as I showed you. Once I compile it and save then I close the VB editor and just have the spreadsheet open. Then I minimize the spreadsheet. This is how it will be run. It will not open the spreadsheet "C:\Documents and Settings\Robert McMahon\My Documents\Macro Program for Reports.xls" I have adjusted my program even to remove the TimeValue and try to input ".5" as the time for excel and it still will not work. If I can figure this out I am going to alter this program to run Every hour. And another one that will run every 15 minutes. But I can't seem to get this one to work first.......Here is where I am.... Sub a() Application.OnTime TimeValue("12:00:00"), "Test" End Sub Sub Test() Workbooks.Open "C:\Documents and Settings\Robert McMahon\My Documents\Macro Program for Reports.xls" End Sub Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update a cell with a time. | Excel Discussion (Misc queries) | |||
Fixing time of last update | Excel Worksheet Functions | |||
Update two workbooks at the same time, but not all the time. | Excel Discussion (Misc queries) | |||
Time update | Excel Worksheet Functions | |||
update time | Excel Discussion (Misc queries) |