Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 - SOAP
Is there a way to <easily update a worksheet with a SOAP result? [... I am
looking for something like CopyFromRecordSet with ADO Recordset objects...] The result I have returns a variable number of rows. Each row has several named items, e.g. res(0).Name res(0).DOB etc. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 - SOAP
if your data has already populated a recordset object then yes
if rst is the popu;ated recordset then this line will drop the entire table from row 2 Range("A2").CopyFromRecordset rst for headers, you'll need to loop through the recordset fields with rst for col = 1 to .Fields.Count cells(1,col) = .Fields(col-1).Name 'NOTE:fields are zero based, so 0 to (n-1) for n fields next end with "AA2e72E" wrote in message ... Is there a way to <easily update a worksheet with a SOAP result? [... I am looking for something like CopyFromRecordSet with ADO Recordset objects...] The result I have returns a variable number of rows. Each row has several named items, e.g. res(0).Name res(0).DOB etc. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 unable to detect SOAP 1.2 web service with wsHttpBindin | Excel Programming | |||
Excel 2003 unable to detect Web services with wsHttpBinding (SOAP | Excel Programming | |||
web services using soap excel/VBA | Excel Discussion (Misc queries) | |||
vba & SOAP - which soap library & version? | Excel Programming | |||
Use Excel 2003 XML Map feature to create an SOAP XML file? | Excel Discussion (Misc queries) |