Opening XML files using Office 2000 or VB6

[Amir]

Hi,

I'm using Excel 2000 and I wish to build a VBA macro which will compare
specific fields in a given .xml file to specific fields in a standard Excel
..xls file.
I know the VB / VBA which is needed to compare fields in 2 worksheets, but I
don't know how to open the .xml file using Excel 2000. Is that possible to
open xml file using Excel 2000 or I have to use higher version of Excel?

If it's not possible to do that in Excel 2000, can I use VB6 to do that
despite the fact that I don't have higher version of Excel? How can I use
VB6 to open the records/data in that XML file? Should I use ADODB for that?
Is that possible?
I know it's not a VB discussion group so if you direct me to a better group
for that question it's fine.

I'm using: Office 2000, Windows 2000 Pro, and Visual Studio 6.
I know VBA, some VB and a bit of API calls. I do NOT know VB.NET.

Kind Regards,
Amir.

 

[Gareth]

Microsoft provide an SDK that allows you to work with XML files within
VBA. I've used it with XL2000 in the past.

(I think this is the right link...)
http://www.microsoft.com/downloads/...2b-b4f2-46da-b4b6-c5d7485f2b42&DisplayLang=en

HTH,
G

 

[Amir]

Thanks!

Microsoft provide an SDK that allows you to work with XML files within
VBA. I've used it with XL2000 in the past.

(I think this is the right link...)
http://www.microsoft.com/downloads/...2b-b4f2-46da-b4b6-c5d7485f2b42&DisplayLang=en

HTH,
G

 

[Amir]

Thanks!

Microsoft provide an SDK that allows you to work with XML files within
VBA. I've used it with XL2000 in the past.

(I think this is the right link...)
http://www.microsoft.com/downloads/...2b-b4f2-46da-b4b6-c5d7485f2b42&DisplayLang=en

HTH,
G