Run specific macro at specific time

[YasserKhalil]

Hello everyone
I need to run a specific macro named "Test" at specific time .. exactly at 12 pm
and at all days except Friday and Monday

Thanks advanced for help

 

[YasserKhalil]

Any help in this topic please?

 

[Debaser]

If Excel is open, you can use Application.OnTime. If it won't be open, you need to use Task Scheduler to open Excel and a Workbook_Open routine to run the code.

 

[YasserKhalil]

Is it possible to add task to Task Scheduler using vba in workbook open?

 

[shrivallabha]

Yes. It is possible. Your macro location must be trusted one or else it will popup "Enable Macros" prompt. Or macro security should be low to allow all macros to run which is dangerous.

One more way is using VBScript. We had this discussion on VBAExpress some time back. See if it helps.
http://www.vbaexpress.com/forum/showthread.php?42794-Solved-Initiate-xlsm-file-with-task-scheduler

 

[YasserKhalil]

Thanks a lot for reply
I don't know but it seems there is a problem with the link
Can you provide us the best solution provided in this discuss please?

 

[shrivallabha]

Strange. I can open the link without problem. Is it asking for you to register?

Here's initial code I had posted there. This you need to put in a vbscript file and edit to suit your situation.

'Write Sheet's full path here
strPath = "C:\MyPath\Book1.xlsm"
'Write the macro name including module
strMacro = "Sheet1.Macro2"
'Create an Excel instance and set visibility of the instance
Set objApp = CreateObject("Excel.Application")
objApp.Visible = False
'Open workbook; Run Macro; Save Workbook with changes; Close; Quit Excel
Set wbToRun = objApp.Workbooks.Open(strPath)
objApp.Run wbToRun.Name & "!" & strMacro
wbToRun.Save
wbToRun.Close
objApp.Quit
'Leaves an onscreen message!
MsgBox "Code Running Was Successful!", vbInformation

 

[Debaser]

Why do you need to add to Task Scheduler using VBA?

 

[YasserKhalil]

Thank you very much Mr. Shivallabha for reply
In fact I ma still a little confused .. the code in put in vbscript file .. Will the code add the task to Task Scheduler? or it will run the macro only
Mr. Debaser It is a way to remind me during work of specific tasks to do ..as I forget most of the times

 

[Debaser]

What I mean is why don't you manually add the task to task scheduler? It's a one time operation.

 

[YasserKhalil]

Ok Mr. Debaser
In fact I didn't use this feature before. Can you guide me in simple steps please?

 

[Debaser]

You never answered my original question - will Excel already be open? If it will, you can just use Application.OnTime to schedule a macro.

Do you not have Outlook?

 

[YasserKhalil]

Sorry Mr. Debaser I didn't notice the question
As for the device will be open but excel may be or may be not open ..
If opened at the specific time I can manage a code using Application.OnTime as you mentioned ( I know that point) but what if the excel is not open ..that's my problem so I had to use task scheduler

 

[Debaser]

See for example: http://windows.microsoft.com/en-gb/windows/schedule-task#1TC=windows-7

 

[YasserKhalil]

Thank you very much Mr. Debaser for great help

 

[shrivallabha]

Thank you very much Mr. Shivallabha for reply
In fact I ma still a little confused .. the code in put in vbscript file .. Will the code add the task to Task Scheduler? or it will run the macro only
Mr. Debaser It is a way to remind me during work of specific tasks to do ..as I forget most of the times

Above code is for running a specific macro.

1. Create VBScript which runs specific macro like one showed above and save it as *.vbs file. For this you can use Notepad.
2. Schedule the vbscript as per your requirements.

 

[YasserKhalil]

Thank you very much
Now I could get it completely ..thanks a lot for great help