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
|