I'm looking for a vba macro that will convert an excel file to xml. I found
this web site that has a vba macro created that does exactly what I want it
to, however when I imported the code as a module it did not work.

Here's where I got the vba code:
http://www.meadinkent.co.uk/xl_xml1.htm

I'm using Excel 2003 and have never installed a macro before, so I could be
doing something wrong, but when I try to run the macro, I get a message that
says "Compile Error: Syntax Error"


Thanks for your help

Assuming that you cut and pasted into a new module using the VBE editor...

Click anywhere in the code (for VBE click on sheet then alt &F11 and then
click on Debug)
the problem line of code should show up highlighted and you can repost it here

"Jacob" wrote:

I'm looking for a vba macro that will convert an excel file to xml. I found
this web site that has a vba macro created that does exactly what I want it
to, however when I imported the code as a module it did not work.

Here's where I got the vba code:
http://www.meadinkent.co.uk/xl_xml1.htm

I'm using Excel 2003 and have never installed a macro before, so I could be
doing something wrong, but when I try to run the macro, I get a message that
says "Compile Error: Syntax Error"


Thanks for your help