converting excel to xml
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 |
converting excel to xml
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 |
All times are GMT +1. The time now is 10:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com