View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] georgesmailuk@gmail.com is offline
external usenet poster
 
Posts: 13
Default 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