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.

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/d...DisplayLang=en

HTH,
G

Amir wrote:
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.

Thanks!

"Gareth" <nah wrote in message
...
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/d...DisplayLang=en

HTH,
G

Amir wrote:
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.

Thanks!

"Gareth" <nah wrote in message
...
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/d...DisplayLang=en

HTH,
G

Amir wrote:
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.