Importing External data 1

[ADE6]

Hi

I am importing Financial Market data into Excel,this seems to work ok,i would like the updates to take place at a specific time of day.

I have looked at the External Data Range Properties box(refresh control)this allows three options,none of which are what i really need.

I would like to refresh the data at 22:05 B.S.T,is it possible to write code to control this process.


Thanks for the ideas

Ade

 

[SkipVought]

Ade,

You can use a small amount ot VBA code to accomplish this. In a Module paste...

Sub ActivateTimer()
 Application.OnTime TimeValue("22:05:00"), "RefreshQuery"
Sub RefreshQuery()
  Worksheets("YourSheet").QueryTables(1).Refresh
End Sub

Then in the ThisWorkbook Object

Private Sub Workbook_Open()
  ActivateTimer
End Sub

So when you open the workbook, ActivateTimer turns the timer on to run RefreshQuery at the desired time.

Just name the Worksheet properly in that routine.


Skip,
[sub]
[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive! [/sub]