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.