Opening a sheet at a certain time

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi,

I would like to have a macro that can open a spreadsheet
automatically on my computer at a certain time (1 AM). I
would leave my computer and Excel on during this time
(overnight) Is there a way I can do this?

The document I want opened can be found at:
"C:\Documents and Settings\MIKE\My Documents\track.xls"


Your help would be appreciated.

Mike
 
If you're using WinNT/2k/XP/2003, you can use the AT command.

From a command prompt, type AT /?

/i.
 
Thanks for the response.

I'm sorry to say that I have no programming experience so
I fail to understand your response. BTW, I'm using XP.
 
Mike,

Is Application.OnTime what you are looking for? See more in VBA Help.

HTH
Anders Silvén
 
Mike,

Same on XP.

Goto theStart Menu, and select Run.
In the Open box, type cmd
You should then get an old style DOS command window
Type AT/? in there and it gives you instructions to run AT.

I would use the builtin scheduler though.

Again, go to Start, but select Help.
Type in 'scheduled a new task' without the quotes and follow tyhe
instructions.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
thanks for your help.

Mike


-----Original Message-----
Mike,

Same on XP.

Goto theStart Menu, and select Run.
In the Open box, type cmd
You should then get an old style DOS command window
Type AT/? in there and it gives you instructions to run AT.

I would use the builtin scheduler though.

Again, go to Start, but select Help.
Type in 'scheduled a new task' without the quotes and follow tyhe
instructions.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Back
Top