XML File Source

[GBPAUDEUR]

Hello, I'm just getting started with understanding the process of importing external information from an XML file into Excel. I'm working with some older files that were created several years ago. I was wondering what the best approach is to determine what source XML file the import process is relying upon? Stated differently, how can I determine the location of the XML file that's being used?

Thanks and sorry for the very basic question.

Thanks,
GBPAUDEUR

 

[GBPAUDEUR]

Bump...basically, I just need to know what XML file is being sourced. I believe it's buried somewhere in a folder but cna't find it through standard search techniques. Nay help is greatly appreciated.

 

[mrhstn]

Hi, welcome to the forum

Create a copy of your workbook, change it's file extension to .zip, you can now access the documents XML elements from the zip file.

 

[GBPAUDEUR]

mrhstn - that worked! Thanks.