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!
Bookmarks