Web Query - row is too long
 

I am running a web query to get back XML data from a soap service web
view ( WebLogic to be precise ) However the row with all the data is
thousands of characters long. This results in a blank line showing.
Is there any way to get this data and the split it up before trying to
write it to excel?
Or does anyone know of any ways to connect to a URL and parse the data
in a fairly simplistic way?

Thanks
Tom

Web Query - row is too long
 

You could try using the xmlhttp object to run the query and get an XML
document. Tons of examples on the interweb.
The data could then be extracted from that.

Tim

"Tom Med" wrote in message
oups.com...
I am running a web query to get back XML data from a soap service web
view ( WebLogic to be precise ) However the row with all the data is
thousands of characters long. This results in a blank line showing.
Is there any way to get this data and the split it up before trying to
write it to excel?
Or does anyone know of any ways to connect to a URL and parse the data
in a fairly simplistic way?

Thanks
Tom