Tiger 10.4.3 Build 8F46 Breaks Web Queries?

[LRL]

The latest update to Tiger to 10.4.3 build 8F46 appears to have broken my
SpreadSheets ability to perform a web query using VBA. I've tried using older
versions of my SS which I know work plus examples that do simple stock quotes
and they all report 1004 errors, Query failed. The same SS works fine on
Windows machines and under Panther. This is all using Office X Service
Release 1. Office 2004 is completely broken in terms of web queries via VBA.

Anybody else notice this or have a reason for this?

Thanks

Leslie

 

[JE McGimpsey]

The latest update to Tiger to 10.4.3 build 8F46 appears to have broken my
SpreadSheets ability to perform a web query using VBA. I've tried using older
versions of my SS which I know work plus examples that do simple stock quotes
and they all report 1004 errors, Query failed. The same SS works fine on
Windows machines and under Panther. This is all using Office X Service
Release 1. Office 2004 is completely broken in terms of web queries via VBA.

Anybody else notice this or have a reason for this?

First, which XL version are you using - "Office X" SR1 or Office 2004?

Second, I run web queries all the time using Office X (10.1.6) and
Office 2004 (11.2) under Tiger (Mac OS X 10.4.3 (8F46)) both from the
GUI and from VBA, so I suspect it isn't XL that's broken, but you should
make sure whichever version you have is updated.

If you want to post your query, it's possible that it would help to
narrow down the problem.

 

[LRL]

the Test Mac's are as follows:

The following Mac's are all running Tiger 10.4.3 8F46
Dual G5 2.3Ghz
Ti PowerBook G4 400Mhz
iMac G5 20"

The following Mac is running Panther 10.3.9 7W98
Dual G4 500Mhz

The two Excel's I'm testing on are Office X Service Release 1 10.1.6
(040913) and Office 2004 11.2.0 (050714)

The query I'm using in VBA is

For Each myQT In myWS.QueryTables
myQT.Delete
Next myQT
On Error GoTo HdlConnectionErr
Set myQT = myWS.QueryTables.Add(Connection:= _
"URL;https://www.mywebsite.com/cgi-bin-local/mystuff.cgi/",
Destination:=destinationRng)
With myQT

.BackgroundQuery = False
.PostText = myPostText
.SaveData = True
.TablesOnlyFromHTML = False
.Name = "myReturnedData"
.RefreshStyle = xlOverwriteCells

.Refresh BackgroundQuery:=False

End With
On Error GoTo 0

The SS works under Panther and most flavors of Windows 2000 and up and Excel
2000 on up.

The query will fail with error number 1004 and message "Method 'Refresh' of
object '_QueryTable' failed.

This all used to work prior to the last update to Tiger. Archived copies of
the SS which all used to work, also fail. Unfortunately, I've not found
someone who has not updated and is also running Office X to confirm my theory
and I haven't figured out how to back out the updates without completely
re-installing Tiger.

Previous posts have noted a problem in Office 2004 and queries such as the
one above.

If you have queries that are working, it would be great if I can find out
what the secret is.

Thanks for your help.

 

[JE McGimpsey]

If you have queries that are working, it would be great if I can find out
what the secret is.

Hard to tell with your code - I get a "server not found" error. However,
the code isn't very different than queries I've written for clients that
work fine in XL04 and Tiger.

From looking at previous posts, I'm not sure the problems have been well
characterized, so I'm unable to even hazard a guess as to where the
problem lies.