Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query text too long | Excel Programming | |||
How can I use a long URL in a web query? | Excel Discussion (Misc queries) | |||
Loading MS Query takes a long time | Excel Worksheet Functions | |||
How to enter a long address to new web query | Excel Discussion (Misc queries) | |||
MyODBC & Excel VBA - Too long query ? | Excel Programming |