ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open workbook with scheduled tasks? (https://www.excelbanter.com/excel-programming/330503-open-workbook-scheduled-tasks.html)

[email protected]

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


[email protected]

Open workbook with scheduled tasks?
 
Typical - you spend hours searching for the answer and then you find it
after you ask for help.

http://www.kellys-korner-xp.co*m/xp_abc.htm

Click on S and scroll to "Scheduled Tasks

But thanks for reading this, : )



All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com