I am hoping that someone can assist. I need a VBA code that will prompt the user to open an excel file from one folder and save as an XML or any type of file for that matter in another folder.

So for example, Open folder on File Path A, Select excel File, Open and Save as XML file (or any other file) in File Path B.

Any suggestions?