Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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, : )

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows Scheduled Tasks Norm Excel Discussion (Misc queries) 2 April 30th 10 06:44 AM
How to open 2 excel instances by using XP schedule tasks? Eric Excel Discussion (Misc queries) 2 April 22nd 10 01:00 PM
What is correct syntax when using Scheduled Tasks? Doug Excel Discussion (Misc queries) 0 March 9th 09 03:49 PM
How to open multiple excel files as separate tasks on the taskbar? Bread Setting up and Configuration of Excel 6 October 12th 08 12:39 PM
starting macros via scheduled tasks mnichols Excel Programming 1 May 24th 04 09:37 AM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"