Refreshing an Excel Query

  • Thread starter Thread starter DWIGHTBALLMORRILL
  • Start date Start date
D

DWIGHTBALLMORRILL

Is there a way to setup a Query to automatically refresh when you open it up?
 
hi
Private Sub Workbook_Open()
Sheets("sheet1").Range("A1").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
End Sub
edit the range address to suit your data.

regards
FSt1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Database Query Missing 4
Refreshing a query 1
Automatic Query Refresh 4
Stopping "Query Refresh" messages 2
Automatic Webquery Refresh 1
Excel 2003 randomly loosing database queries 1
enable automatic refresh 4

Back
Top