Hi
I have a workbook that refreshes each time it is opened using the File menu Data -> Import External Data.

When I save the spreadsheet I want to break the link to the csv file, I would like to do it via a macro/VBA. Unselect the below, rather than have the user select data properties and manually untick the save query definition

External Data Range Properties -> Query Definition - >Save Query Definition

Is this possible

Regards

Thereis no need to link to a .csv file. You can use File/open.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.