Hello,

First of all I'm new to VBA, and this is my first post , so be nice please

I have a table in a sheet called "general" that it's updated when i refresh a connection called "general.xml".
As you know, the connection paths cannot be relative, but my spreadsheet has to travel to other systems, so...
I'm trying to update the connection path with a macro.

I already have a dialog box where the user can select the location of the new general.xml file, so i have the new path in a cell.

I want to update the old connection path with the new one, but I don't know how to do that.

Can anyone give me some clues about how to do that?


Thanks in advance for your help!