Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
OK, I posted about this previously, seeking code not browser-
dependent. I've revised my plan and am now attempting to capture the values in a web page drop-down list, via Internet Explorer. I have identified the element that contains the drop-down and can capture its current value, but I want to capture all the values in the list. Any suggestions? Thanks in advance Paul Martin Melbourne, Australia |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just loop through the options and check the .value or .text properties
(depending on which you need). Dim o as object for each o in objList.options debug.print o.value & ":" & o.text next o where objList is your reference to the list. Tim "Paul Martin" wrote in message ... OK, I posted about this previously, seeking code not browser- dependent. I've revised my plan and am now attempting to capture the values in a web page drop-down list, via Internet Explorer. I have identified the element that contains the drop-down and can capture its current value, but I want to capture all the values in the list. Any suggestions? Thanks in advance Paul Martin Melbourne, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing Drop down list into new page | Excel Discussion (Misc queries) | |||
How to create a drop down list with different values | New Users to Excel | |||
Drop down list with different values. | Excel Worksheet Functions | |||
Mask Drop Down List values | Excel Discussion (Misc queries) | |||
Clearing the Values in a Drop - Down List | Excel Discussion (Misc queries) |