Running VB script to run from scheduler

[jessiegeorgia]

Hi All,

I'm new to VB so having written something that works (with help from the MrExcel community) I'd like to add it to a scheduler to run on the first of the month.
However, my code only runs when I open the file and run it myself, in order to run from the scheduler I need it to run automatically on opening. Do I change this in the code or is it in the tools or somewhere else???

Many thanks in advance,
Jess

 

[Trevor G]

On teh desktop scheduler you can set it to run at the beginning of the month, select your desktop, then press F1 then type schedule, once it finds the help topic click the link then in the console select the Help menu and look at Schedule and trigger this is what they say

If you select the Monthly radio button, you choose the months in which you want to start the task and the weeks of the month and the days of the week for each month in which you want to start the task. You can also specify that you want to start a task on the last day of each month.

Then when you test this, the task also needs to run the macro within the workbook.

This link gives you the command line to run a macro

http://support.microsoft.com/kb/213837