Failed Web Query ... sometimes
 

Some were using Office XP,
some Office 2000, etc.
Probably the problem
You may have to write 2 procedures
If application.version=
do this
else
do that
--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Mark Kopytek" wrote in message
...
I would appreciate some help from you excel gurus on a
problem I've encountered. Here it is:

I am using a web query to extract data from an online CRM
database (that employs XML APIs and the .NET platform). I
wrote a macro that downloads the data into Excel. Here
is the heart of the code:

Worksheets("Accounts").Range _
("Account").QueryTable.refresh BackgroundQuery:=False

Worksheets("Forecast").PivotTables _
("funneltable").RefreshTable

I created the program in Excel 2002, and it works fine on
my computer (all tables refresh as expected). I then
deployed the program to the sales team, with mixed
results: for some it worked fine, but others found the
tables would not refresh (with no resulting error
message - just empty tables). Some were using Office XP,
some Office 2000, etc.

Any ideas?

Thanks, Mark

Failed Web Query ... sometimes
 

Don,

Thanks for your reply re my VBA problem. The interesting thing is that
some Excel 2002 users are not able to run the program successfully, but
some Excel 2002 are able. As well, some Excel 2000 users are not able
to run the program, but some are. That's what makes it so troublesome.

Any other ideas?

Thanks
Mark


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!