create a macro to save excel sheet

[Moussa Hawas]

I am asking for your help, as I am in a great trouble.
I want to do the following in a simple way.
I am working on an excel file that contains only one sheet.
That excel sheet is linked to Reuters to get the prices of stocks every
second live.
I want that file to save its latest figures been donwloaded from Reuters
automatically at certain hour of day while I am away from my office. Did you
get it?

Let me say it again, I want a code to write in Visual Basic or macros, to
make that excel sheet to be saved automatically when the clock of the
computer turns to be 11:00 pm every day while I am away from my desk.

Thanks.
Moussa Hawas
Analyst, Egypt Stock Market.
(e-mail address removed)

 

[Richard Buttrey]

On Sun, 16 Oct 2005 12:51:01 -0700, Moussa Hawas <Moussa

I am asking for your help, as I am in a great trouble.
I want to do the following in a simple way.
I am working on an excel file that contains only one sheet.
That excel sheet is linked to Reuters to get the prices of stocks every
second live.
I want that file to save its latest figures been donwloaded from Reuters
automatically at certain hour of day while I am away from my office. Did you
get it?

Let me say it again, I want a code to write in Visual Basic or macros, to
make that excel sheet to be saved automatically when the clock of the
computer turns to be 11:00 pm every day while I am away from my desk.

Thanks.
Moussa Hawas
Analyst, Egypt Stock Market.
(e-mail address removed)

Before leaving your desk set the following macro running.

Public Sub SaveReutersData()
Dim Mytime As Variant
Dim Timenow As Date
Mytime = TimeSerial(23, 0, 0)
Do Until Timenow >Mytime
Timenow = Time
Loop
ActiveWorkbook.Save
End Sub


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________