Macro to refresh query.

[CJPHX]

I currently have a macro that opens a spreadsheet updates the information and closes it. However, some of the data in the worksheet is from an outside query. So everytime the spreadsheet is open it asks to enable automatic refresh. I have used Application.DisplayAlerts = False so I do not see any of the message boxes, so it does not update the information I need. Is there a way to have it click enable auto refresh or once the sheetis opened to refresh the query to ensure all of my information gets updated.

[Leith Ross]

Hello CJPHX,

Since queries can take many forms, it would be helpful if you were more specific. I gather from your post you are referring to a web query you created using the Excel menu. It would save time if you can post a copy of the workbook. The query can then be modified directly.

[CJPHX]

I will try to post a copy of the workbook but it has so much information in it. The query is actually a table/range that just imports data from a .csv file that is saved on a different server. So it asks me to refresh external data.

[CJPHX]

I have decided I can use this code to solve what I need. I select a cell within the range that needs to be refreshed.

Please Login or Register  to view this content.