Mac OS X 10.4.4 PostText broken?

[cultfigure]

I'm trying to post information from an excel 2004 VBA macro, everything
works except the POST info is not sent. GET vars are sent to my web
page just fine, but I need to send a lot more data. The code works
fine on Windows XP running Office 2003:

Dim qtsQueries As QueryTables
Dim qtQuery As QueryTable

Dim strPost As String
strPost = "data=testing a lot of text data here"

Set qtsQueries = ActiveSheet.QueryTables
Set qtQuery = qtsQueries.Add( _
Connection:="URL;http://my_site.com/sys.php?u=blah&p=fjkls", _
Destination:=Range("C5") _
)



With qtQuery
' Posted data
.PostText = strPost

.Refresh

If .FetchedRowOverflow Then
MsgBox "Your request returned too many results. " _
& "Please refine your search.", vbInformation, "Result Error"
End If

.Delete

End With

Any suggestions would be great, thanks!

 

[Jim Gordon MVP]

No promises, but this link might help
http://support.microsoft.com/default.aspx?scid=kb;en-us;187364

-Jim

 

[LRL]

if you do get this to work, I'd be really interested in knowing how you did
it. I've been unable to get the .PostText to work with 2004. The query used
to work with 2001 but after the latest updates to Tiger, it stopped working.
The .PostText will work work on 2001 under Panther FWIW and of course under
Windows.

Your query is very similar to mine. Pretty simple.

Good luck and if you do get it to work, I would welcome your solution.

Leslie

 

[cultfigure]

Thanks Jim, but that doesn't work either. I also tried using stored
web queries with no luck.

Leslie, on one hand I'm glad you replied since I saw you were having
the same issue in another post, on the other hand, it's too bad neither
of us has been able to resolve the problem!?

Unfortunately, a working copy under Panther alone I fear would prove to
be more hassle than not, so that's out of the question. I'll continue
my search over the next couple of weeks and will let you know if I come
up with anything.