Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduling a Macro
i have set up a macro using the Application OnTime function. I have used it
on several excel files and two of them work and two of them don't even though the code is the same. Any ideas why this is happening? I need the macro to run after it is opened, but not run on every opening, so I have tried to schedule it to run at a certain time. Private Sub Worksbooks_Open() Application.OnTime TimeValue("6:45:00"), "Compliance" End Sub (In ThisWorkbook Code) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduling a Macro
Check the posting on 4/20/2009 titled Time Macros on Weekday only. I think
the information you are looking for is in one of the replies. And there are a few websites in there also that would be very helpful. Good luck "Ashlyn R." wrote: i have set up a macro using the Application OnTime function. I have used it on several excel files and two of them work and two of them don't even though the code is the same. Any ideas why this is happening? I need the macro to run after it is opened, but not run on every opening, so I have tried to schedule it to run at a certain time. Private Sub Worksbooks_Open() Application.OnTime TimeValue("6:45:00"), "Compliance" End Sub (In ThisWorkbook Code) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduling a Macro
Hi Ashlyn
It must be Private Sub Workbook_Open() -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ashlyn R." wrote in message ... i have set up a macro using the Application OnTime function. I have used it on several excel files and two of them work and two of them don't even though the code is the same. Any ideas why this is happening? I need the macro to run after it is opened, but not run on every opening, so I have tried to schedule it to run at a certain time. Private Sub Worksbooks_Open() Application.OnTime TimeValue("6:45:00"), "Compliance" End Sub (In ThisWorkbook Code) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduling a Macro
I don't need it scheduled to run on a certain day. I have the file opening
(using Scheduled Tasks) on the days that I need it. I would like to know why the macro works on some files, but not on the others. "Ayo" wrote: Check the posting on 4/20/2009 titled Time Macros on Weekday only. I think the information you are looking for is in one of the replies. And there are a few websites in there also that would be very helpful. Good luck "Ashlyn R." wrote: i have set up a macro using the Application OnTime function. I have used it on several excel files and two of them work and two of them don't even though the code is the same. Any ideas why this is happening? I need the macro to run after it is opened, but not run on every opening, so I have tried to schedule it to run at a certain time. Private Sub Worksbooks_Open() Application.OnTime TimeValue("6:45:00"), "Compliance" End Sub (In ThisWorkbook Code) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduling a Macro
Have you see my reply ?
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ashlyn R." wrote in message ... I don't need it scheduled to run on a certain day. I have the file opening (using Scheduled Tasks) on the days that I need it. I would like to know why the macro works on some files, but not on the others. "Ayo" wrote: Check the posting on 4/20/2009 titled Time Macros on Weekday only. I think the information you are looking for is in one of the replies. And there are a few websites in there also that would be very helpful. Good luck "Ashlyn R." wrote: i have set up a macro using the Application OnTime function. I have used it on several excel files and two of them work and two of them don't even though the code is the same. Any ideas why this is happening? I need the macro to run after it is opened, but not run on every opening, so I have tried to schedule it to run at a certain time. Private Sub Worksbooks_Open() Application.OnTime TimeValue("6:45:00"), "Compliance" End Sub (In ThisWorkbook Code) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scheduling | Excel Worksheet Functions | |||
Scheduling | Excel Programming | |||
Scheduling Macro run | Excel Programming | |||
Scheduling a Macro to Run | Excel Programming | |||
Scheduling a Macro | Excel Programming |