Refreshing MS Query when opening a file

[NigelByrne]

How do I refresh a Microsft Query when opening an Excel workbook. I have tried : -

Private Sub Workbook_Open()

Sheets(1).QueryTables.Refresh BackgroundQuery:=False

End Sub

But it gives me an error, any help would be gratefully recieved.


Regards


Nigel

 

[xlbo]

Right click in the data range, goto DataRange properties and choose "Refresh On Open" Rgds
~Geoff~