Article:		Performing Web Queries in Excel 2003
Subject:		Mac support
Date:		2004-08-11 11:59:44
From:		precipice
Unless I'm missing it, Web queries aren't supported in Mac Excel 2004 (in case anyone is wondering...)

Showing messages 1 through 3 of 3.

• Mac support
  2004-08-12 05:03:12  Jeff Webb | [View]
  
  
  I focused specifically on Excel 2003 for this book. I did find this comment in one Microsoft newsgroup:
  
  "There's almost no difference in XLv.X and XL 97/00/02 as far as XL
  itself is concerned - all functions are cross-platform."
  
  So I'd assume that Web Queries are probably supported, but I don't have a Mac to test them and I couldn't find a comprehensive feature Win/Mac comparison online anywhere.
  
  At one point, Microsoft used the same source code to generate Win/Mac versions of Excel. I don't know if that's still the case (I kinda doubt it, there were performance complaints).
  
  -- Jeff
• Mac support
  2005-09-10 06:13:23  blunt [View]
  
  
  I am having trouble running a query table macro in mac that I created for a file in excel in windows. In one machine it gives me a problem with the Refresh method. I think the error number is '1004'. In that machine I have run it under mac os 9 and excel 2001, and mac OS X and excel 2003. In both cases I get the same error.
  
  Then I tried in a different machine under MAC OS 9 and Excel 2001 and it ran well.
  
  What I'm thinking is that something in the machine configuration is stopping excel from accessing the web query (in my case a web service) but I cannot think exactly what.
  
  Can you help???? Thanks.
• Mac support
  2004-11-25 15:51:53  Talkback [View]
  
  
  Queries are supported, but not automated. You have to write the query scripts yourself in a text editor.