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