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.