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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.