How to generate XML from an Excel VBA macro?

Posted by SuperNES on Stack Overflow See other posts from Stack Overflow or by SuperNES
Published on 2010-05-04T15:40:23Z Indexed on 2010/05/04 17:08 UTC
Read the original article Hit count: 272

Filed under:
|
|

So, I've got a bunch of content that was delivered to us in the form of Excel spreadsheets. I need to take that content and push it into another system. The other system takes its input from an XML file. I could do all of this by hand (and trust me, management has no problem making me do that!), but I'm hoping there's an easy way to write an Excel macro that would generate the XML I need instead. This seems like a better solution to me, as this is a job that will need to be repeated regularly (we'll be getting a LOT of content in Excel sheets) and it just makes sense to have a batch tool that does it for us.

However, I've never experimented with generating XML from Excel spreadsheets before. I have a little VBA knowledge but I'm a newbie to XML. I guess my problem in Googling this is that I don't even know what to Google for. Can anyone give me a little direction to get me started? Does my idea sound like the right way to approach this problem, or am I overlooking something obvious?

Thanks StackOverflow!

© Stack Overflow or respective owner

Related posts about excel

Related posts about Xml