Export to XML from different worksheets (to different files)

C

cfmartin76

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!!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top