Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 236
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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?
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compatibility Issue WLMPilot Excel Discussion (Misc queries) 2 May 1st 10 10:23 PM
Compatibility Issue WLMPilot Excel Discussion (Misc queries) 2 March 8th 10 01:43 PM
Excel 2003 compatibility issue news4naeem Excel Discussion (Misc queries) 0 January 15th 10 06:06 AM
could the #NAME? error be a compatibility issue? sweetsourpork New Users to Excel 2 November 23rd 07 07:35 PM
Code compatibility issue iamrajy[_4_] Excel Programming 1 October 17th 05 07:32 PM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"