View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ale ale is offline
external usenet poster
 
Posts: 14
Default 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