run macro on PC boot-up

[xidnad]

I have a macro I would like to run once a day (not everytime I open Excel). I have tried storing the workbook with the macro in my Start Up folder and sometimes it runs and sometimes it doesn't. I am using Windows & Excel 2000. I also have a virus scan that runs at boot-up and am wondering if this might be the cause of my problem. Any ideas?

 

[longhair]

xidnad,
what i would do is use a scheduled task. you can set it to run on startup, at logon, etc.
hth
regards,
longhair

 

[macropod]

Hi xidnad,

Do you want the macro to run (a) once every day, regardless of whether you manually start Excel, or (b) only once a day if Excel is started?

Cheers

 

[xidnad]

macropod,
That would be once a day regardless of whether I manually start Excel.
Thanks for asking,
xidnad

 

[longhair]

xidnad,
like i said - use a scheduled task.
put the macro in a workbook.
in scheduled tasks call workbook.xls.
regards,
longhair

 

[xidnad]

longhair,
So sorry I forgot to say thanks. I do believe that that is my best option.
Thank you,
xidnad

 

[longhair]

xidnad,
not your only option but the quickest / free option.
you could purchase software, such as automate -

http://www.unisyn.com.

but why would you for 1 simple task?
regards,
longhair