Can you control a data connection by cell reference

[gassiusmax]

Hi,

I want to establish a data connection that looks at a web based csv, comma delimited file. I can do this manually but I need to be able to say that the path of the CSV file is stored in a specific cell.

On the file attached for the example B3 on Data Connections is where the csv path is held, but I can not seem to get a data connection to look at that with out having to manually create the connection.

If anyone can advise that world be great

Thanks

Danny

[spitfireblue]

You could setup a macro that changes the connection:

Please Login or Register  to view this content.

You could setup the Data Connections page to start the macro when you change the dropdown i.e.

Please Login or Register  to view this content.

[gassiusmax]

Thanks for the Input, this would be a great way going forward as I can set the VBA to run on startup.

But unless I am missing something I get the following error

'run-time error '1004' Application-defined Name of object-defined mirror on the line

Please Login or Register  to view this content.

Thanks

Danny

[spitfireblue]

Sorry, I have been offline for the past few days.
My guess is that the Query Table is not located in cell A1, so just change the A1 to where the table is located