Quick XmlImport Compatibility issue

[Kigol]

I have a macro that uses the XmlImport method to pull a RSS from a
URL. It is not working on the new machine/network I am on, producing
the error "Method or property is available only in Microsoft Office
2003 Professional." Now normally I would say ok fine, I am running
Office 2003 Standard so it won't work. But upon investigation in the
help file I discovered it says "Microsoft Office Professional Edition
2003 and Microsoft Office Excel 2003". To me this means Office 2003
professional OR just excel 2003. It doesn't however look to be the
case. Can anyone confirm?

 

[Guest]

The way I understand it you'll need both.

Using the link below I found some information depicted:
http://www.winsupersite.com/showcase/office2003_editions.asp

I'm using the XML import and export myself. I'd like to know how to test
what excel version and office edition i'm running to inform the user that the
XML features will not work

Editions:
Microsoft Office Student and Teacher Edition 2003
Microsoft Office Basic Edition 2003
Microsoft Office Standard Edition 2003
Microsoft Office Small Business Edition 2003
Microsoft Office Professional Edition 2003
Microsoft Office Professional Enterprise Edition 2003

Using "Application.Version" I get the version.
Does anyone know how to test the office edition in VBA?

 

[gimme_this_gimme_that]

Have you guys tried installing MSXML6.0 and seeing if that gives you
the XML libraries you need?

http://www.microsoft.com/downloads/...CF-3BCF-4009-BE21-27E85E1857B1&displaylang=en

 

[Guest]

Thanks for your reply. I already had MSXML6.0 installed.

My question is: how can I test in VBA what edition of Office a user is
running?

 

[Guest]

In a post from Michel Pierron I read about the property
Application.ArbitraryXMLSupportAvailable

This will tell me what I need to know. Thank you Michel!