PDA

View Full Version : Looking to learn how to parse XML files into Excel with VBA



rlv
01-05-2008, 09:15 PM
Hi, I'm new to the forum. I stumbled over it googling around for information on VBA an XML.

I am looking to learn how to parse XML files with VBA to read the data into a worksheet. I don't need to worry about writing to XML files yet.

I'm using XL2000 sp-3 and I'd appreciate any references to code snippets, sample programs, or decent books that talk about it. Particularly anything that explains or demonstrates how to use the methods and properties in the msxml6.dll library.

Thanks.

Bob Phillips
01-06-2008, 03:38 AM
Best I could do

Putting XML To Work
http://msdn2.microsoft.com/en-us/library/aa163921(office.10).aspx

rlv
01-06-2008, 08:51 AM
Thank you. That link looks promising.