Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Combo Box & Web Service
Hello
How can I load the values from a web service to combo box in excel ? The web service returns a dataset with ID and TEXT Thank you Athan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Combo Box & Web Service
define returns.
Is it held in an array. Is it placed on a worksheet. It is stored in a file? -- Regards, Tom Ogilvy "Athan" wrote in message ... Hello How can I load the values from a web service to combo box in excel ? The web service returns a dataset with ID and TEXT Thank you Athan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Combo Box & Web Service
The dataset is held in an array,
I don't know how to place it on a worksheet, and bind it to the combo box Thank you Athan "Tom Ogilvy" wrote in message ... define returns. Is it held in an array. Is it placed on a worksheet. It is stored in a file? -- Regards, Tom Ogilvy "Athan" wrote in message ... Hello How can I load the values from a web service to combo box in excel ? The web service returns a dataset with ID and TEXT Thank you Athan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Combo Box & Web Service
assume the array name is v
lb1 = lbound(v,1) lb2 = lbound(v,2) ub1 = ubound(v,1) ub2 = ubound(v,2) set rng = range("A1").Resize(ub1-lb1+1,ub2-lb2+1) rng.Value = v ActiveSheet.Combobox1.ListFillRange = rng.Address(external:=True) -- Regards, Tom Ogilvy "Athan" wrote in message ... The dataset is held in an array, I don't know how to place it on a worksheet, and bind it to the combo box Thank you Athan "Tom Ogilvy" wrote in message ... define returns. Is it held in an array. Is it placed on a worksheet. It is stored in a file? -- Regards, Tom Ogilvy "Athan" wrote in message ... Hello How can I load the values from a web service to combo box in excel ? The web service returns a dataset with ID and TEXT Thank you Athan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel calling WCF service | Excel Discussion (Misc queries) | |||
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
How do I run Excel as a service? | Setting up and Configuration of Excel | |||
Excel as a service ? | Excel Programming | |||
Difference between a Service Release and a Service Pack? | Excel Programming |