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

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

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

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)

"Ale" wrote in message
...
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

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

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

Ian

"Ale" wrote in message
...
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

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

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


"Ian" wrote:

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

Ian

"Ale" wrote in message
...
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

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

Thank you guys. My project is finished.



"Ale" wrote:

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


"Ian" wrote:

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

Ian

"Ale" wrote in message
...
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