Opening a sheet at a certain time

[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

 

[immanuel]

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

From a command prompt, type AT /?

/i.

 

[Mike]

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.

 

[Anders S]

Mike,

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

HTH
Anders Silvén

 

[Bob Phillips]

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)

 

[Mike]

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)




.