Use Browse for Querty Refresh

rpaulson

Well-known Member
Joined
Oct 4, 2007
Messages
1,143
Here is my code:

Code:
Sub Import()
Range("C8").QueryTable.Refresh BackgroundQuery:=False

currently when it open the browse the file name and type are already populated with the previous file name.

I wish to set the default folder to open file, and I wish to display all the *.iif files so the user can select one.

Thanks for looking,

Ross
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,884
You are refreshing a QueryTable that already exists. What is the .CommandText for that query? It may be possible to use Application.GetOpenFilename to get the desired directory then rewrite the .CommandText value to use the file obtained with Application.GetOpenFilename.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,514
Messages
5,602,086
Members
414,501
Latest member
mdhaumyu

We've detected that you are using an adblocker.

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.
Go back
Top