ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  Performing Web Queries in Excel 2003
Subject:   Mac support
Date:   2005-09-10 06:13:23
From:   blunt
Response to: Mac support

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.