Open workbook with scheduled tasks?
I am using Excel 97 and on an XP system. I am on the company network so
i have a login and password.
I must be getting really dim, because i can't get this to work at all.
What i would like is for a workbook to be opened at a certain time
every day. An Open workbook macro will then do a repetative task -
while i am out to lunch.
At least that was the plan.
Can someone please walk me through what to do?
I can get to the scheduled tasks in the control panel, create a new
task, but when i have entered the path and file, and the location of
excel that it "starts in" i get various errors.
If i use my own id and password, an error message says that the id or
password is incorrect. I read somewhere that you need to use the
administrator password. The only administrator password i know is used
by our IT dept - but i also know the password so when i use that it
says "running" and nothing else seems to be happening.
I checked the running processes and excel is running with user name -
administrator, but the workbook doesn't appear.
I even tried puting the file in the startup folder to see if i could
get it to run in the morning when i login, but all that happens is that
excel eventually load up - but without any worbooks loading.
Please help
George
|