Below, I have an Excel VBA statement that takes 20 MINUTES to complete:
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
Versus, when I right-click the query table in the sheet and manually hit "Refresh" - it only takes 10 SECONDS to complete!
What's the deal? Is the VBA...
Hi
I'm new to using List Objects and Query Tables in VBA, and have been using some of the many tips I've found through Google, but I'm a bit stuck now.
I am writing some VBA to:
check if a List Object Query Table already exists
if it doesn't, I want to create it using passed SQL and...
I have the following VBA code which is failing with an "incomplete datasource" error on the last line:
Application.ScreenUpdating = False
Worksheets(Import).Select
Range("F10").Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
The name of the ListObject is...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.