CODEWITHSUNDEEP
excelvba
Michel Lemieux
Michel Lemieux

Reputation: 113

Refresh Data on single sheet

I would like to Refresh Data on a single sheet. That is to re-import the External Data text file.

I can do this by clicking on the Refresh Data button (on the Data tab), but I want to find the equivalent in VBA.

Upvotes: 0

Views: 14131

Answers (1)

Michel Lemieux
Michel Lemieux

Reputation: 113

ActiveSheet.QueryTables.Item(1).Refresh

Upvotes: 1

Related Questions