Anybody know a way to convert a spreadsheet into an XML document, where the column headings are the markup tags? Or point me me in the direction of maybe figuring this out?

Just wondering if anybody's done this before or can suggest a better way as i stumble through learning this

probably just as easy to write a VbA script to output a text file.

VbA and XML forums at www.tek-tips.com

Originally Posted by chrishirst

probably just as easy to write a VbA script to output a text file.

VbA and XML forums at www.tek-tips.com

Yea, it looks like that's the way to do it.. i was hoping maybe someone here had already tackled it since i haven't written any VB since college

Thanks for the link, i'll check it out... I'm about to give this a try: http://www.freevbcode.com/ShowCode.Asp?ID=2300