Hi there I need a macro to run at 6 o'clock in the morning every Friday. How would I go about doing this?
Do I need a windows scheduled task, use onTime event, use a DTS package.
I am unsure at present.
Thanks
Bob
Hi there I need a macro to run at 6 o'clock in the morning every Friday. How would I go about doing this?
Do I need a windows scheduled task, use onTime event, use a DTS package.
I am unsure at present.
Thanks
Bob
Re: Schedule Issue
Cheers for the link. However, I have a few questions:
The first problem will be how to kick-off the OnTime Method. This we can do via the Workbook Open Event. The fastest way to get to the Private Module of the Workbook Object (ThisWorkbook) is to right click on the Excel icon next to "File" and select "View Code"
Does this mean that the workbook has to be opened for the OnTime method to work if it fires off on the workbook open event?
Re: Schedule Issue
Yes, but you could use Windows Scheduler for this.
Re: Schedule Issue
If I used windows scheduler then when the workbook opens normally the security will ask whether to enable or disable the macros.
Won't windows scheduler automatically disable the macro, or will I have to play around with the security for that the xls has a low security setting?
Re: Schedule Issue
hi Dave,
kindly give me the code for when work book open security level go to low
OR
when workbook open automatically enable the macro ...
any solution for above ?
Thanks - Jigar
Re: Schedule Issue
jigar987, please read the rules to which you agreed when joining this forum. I know you haven't read them else you wouldn't be asking your question about security.
Don’t have an account yet? Register yourself now and be a part of our community!