Export to XML from different worksheets (to different files)
 

I think I''m losing my mind, I've been looking everywhere but I cannot
seem to find a macro to do the following:
* I need the ability to export multiple XML files from a single Excel
document.
* Ideally I will have worksheet and every column would export to a
separate XML file (column A would be the "tag name" for all XMLs). If
this is not possible, then I would be open to have separate worksheets
instead of separate columns
* I would like to name each XML based on the top row (B1, C1, etc).

Is there a macro that can do this? I havent been able to find a macro
that takes care of all the needs above.

Help!!!!!