How can I get access to readyState 3 with VBA "AJAX"?
January 8, 2013 10:35 AM Subscribe
I'm writing some VBA code (in Excel) which uses a reference to
Microsoft XML, v6.0
, and creates a
I used the
example from this page
as a starting-off point.
How can I access the response text when readyState = 3?
posted by jozxyqk to Computers & Internet (10 answers total)
The example works fine for smallish requests.
But when the response is sufficiently large, Excel will freeze up into a "(Not Responding)" state and sometimes come back and sometimes seem to hang forever.
I know about readyState 3, but when I check for it, it seems that
responseStream is either empty or "non-readable".
Is there something I am missing about how to get access to the stream of data as it arrives with this object?
Is there an alternative object I can use from within VBA to accomplish the desired result?
Preferably with code examples?
My stackexchange-fu has failed on this one; my similar question there has been met with silence.