Understood. But due to some filing protocols in the company, they would eventually need to. Example, I'm using this file on my laptop with a specific directory and they are using it with a different directory.

On a different note, can this code be used to extract excel file instead of .xml (such as .xls etc..) Can I tweak it? And can it be done for the third VBA you suggested - as it's most interesting