Women in Technology

Article:		Performing Web Queries in Excel 2003
Subject:		Mac support
Date:		2004-08-12 05:03:12
From:		JeffWebb
Response to: Mac support
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

Showing messages 1 through 2 of 2.

• 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.