Quick XmlImport Compatibility issue
 

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?

Quick XmlImport Compatibility issue
 

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

http://www.microsoft.com/downloads/d...displaylang=en

Quick XmlImport Compatibility issue
 

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?

Quick XmlImport Compatibility issue
 

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!