How to code VBA or else to open Excel and run Macro as Daily routi

[Guest]

Hi,

I would like to set my pc time to run Macro in Excel.
I feel that have to deal with RegEdit. Howeve, I don't know what to start.
Now I have done with my VBA code in Excel to my work. I need someting more
to automated Macro run as Daily routine. I means everyday in the morning I
opend my computer and I open my pc overnight , every 7.00 am I need a
command to automated run macro in Excel done my daily routine.

Please give me suggestions.

Thanks in advanced,

Ale

 

[Bob Phillips]

See http://www.cpearson.com/excel/ontime.htm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ian]

You can use Windows Scheduled Tasks to open Excel with a specific workbook
and set the macro to run on opening the workbook.

Ian

 

[Guest]

Do you have any example how to set Windows Schedual Tasks? I think it would
work dor my project. However, I have a question in my mind about the
password. Is the password to access the workbooks or the password that I use
to access the computer. In my company, we use username and passwrod to login
our computer and also for a sharing drive that we use different password but
same usename. My excel workbook is on the sharing drive. So what should I do?

Sorry, my one question is long .

Ale

 

[Guest]

Thank you guys. My project is finished.

Do you have any example how to set Windows Schedual Tasks? I think it would
work dor my project. However, I have a question in my mind about the
password. Is the password to access the workbooks or the password that I use
to access the computer. In my company, we use username and passwrod to login
our computer and also for a sharing drive that we use different password but
same usename. My excel workbook is on the sharing drive. So what should I do?

Sorry, my one question is long .

Ale