Windows Task Scheduler and automatic Macro

[Steven1985]

Hi,

I have a daily spreadsheet template that will be copied each day of the week with new data for analysts to work.
I have a macro set up to automatically send an e-mail to the analysts when there account referral is over 3 days. This is working fine.

What i need is for this to run without opening Excel as the analysts wont need to re open the previous days spreadsheet.

Does anyone have a suggestion to help with this please, someones mentioned Windows Task Scheduler??

Thanks

 

[Trevor G]

You would need to open up your control panel, look at Administrative Tasks, then look at Schedule tasks then look to create a task and follow the steps from there. When using this method if on your PC you have to have your PC swithced on to run it.

 

[Steven1985]

I dont seem to have Administrative Tasks on my work pc under control panel???

Is there no other was this can run?

 

[Trevor G]

Which version of Windows are you using?

When you open the Control Panel do you see all the normal things you would expect to see or is there a restriction?

The following comes from my help system so see if this helps:

You can start the Task Scheduler MMC snap-in by using a single command from the command line or by using the Windows interface. Task Scheduler can also be started by double-clicking the Taskschd.msc file in the %SYSTEMROOT%\System32 folder. 
<TABLE class=alertTable cellSpacing=0 cellPadding=0><TBODY><TR><TD class=imgCell></TD><TD class=procHeadingCell>[B]To Run Task Scheduler using the Windows interface[/B]</TD></TR></TBODY></TABLE><?xml:namespace prefix = ddue ns = "http://ddue.schemas.microsoft.com/authoring/2003/5" /><ddue:steps xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">[LIST=1]
[*]<?XML:NAMESPACE PREFIX = [default] http://ddue.schemas.microsoft.com/authoring/2003/5 NS = "http://ddue.schemas.microsoft.com/authoring/2003/5" /><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Click the [B]Start[/B] button.
</content>
[*]<content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Click [B]Control Panel[/B].
</content>
[*]<content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Click [B]System and Maintenance[/B].
</content>
[*]<content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Click [B]Administrative Tools[/B].
</content>
[*]<content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Double-click [B]Task Scheduler[/B].
</content>
[/LIST]</ddue:steps><TABLE class=alertTable cellSpacing=0 cellPadding=0><TBODY><TR><TD class=imgCell></TD><TD class=procHeadingCell>[B]To Run Task Scheduler from the Command Line[/B]</TD></TR></TBODY></TABLE><ddue:steps xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">[LIST=1]
[*]<content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Open a command prompt. To open a command prompt, click [B]Start[/B], click [B]All Programs[/B], click [B]Accessories[/B], and then click [B]Command Prompt[/B].
</content>
[*]<content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">At the command prompt, type [B]Taskschd.msc[/B].
</content>
[/LIST]</ddue:steps>The Schtasks.exe command line tool enables a user to complete many of the same operations that they can complete using the Task Scheduler MMC snap-in. This tool enables a user to create, delete, query, change, run, and end scheduled tasks on a local or remote computer. This tool is located in the %SYSTEMROOT%\System32 folder. Type [B]Schtasks.exe /?[/B] from a command prompt window to view the help for the tool.

 

[Steven1985]

Windows XP. Theres a restiction on what i can view, i have Accessibility options, display, keyboared, mail, mouse, sound & speech.

I dont have command prompt on my Accessories either.

 

[Trevor G]

If you have restrictions you would have to ask your system administrators to create the task for you.