Automatically update path for linked xml

[sandeepkhans]

Hi, I am new to using macros. I use xml mapped excel to extract flight planning information. However, when I send the excel and xml files through email to other users, the mapping link does not work obviously.
Is there any way so that when these files are loaded on a new machine, the updated file directory of the xml file is automatically updated in the macro as soon as the excel is opened on the new machine for the first time?

ActiveWorkbook.XmlMaps("FlightPlan_Map").Import Url:= _
C:\Users\Dell\Desktop\FPL_IL\XPS.txt

 

[severynm]

Hello. Off of the top of my head, you can accomplish this a few ways.

The easiest solution might be to mandate that the excel and xml file are saved in the same folder, and get the path of that folder with ThisWorkbook.Path. That way you can pick up the correct folder no matter where the user saves it.

Second, you could use a FileDialog to prompt the user to open the file (I am unsure if this will work on macOS or not). If you are interested, I can share a sample that I am using.