Accessing controls in excel using vbscript
 

I have an excel sheet which populates values based on a value selected in a
combobox. I am using a vbscript code to access this excel and generate an
html page.

My requirement is to generate seperate html page based on each value in the
excel combobox.

Using vbscript i need to write
I need to identify the combo list items.
I need to repopluate the excel for each combo values before generating the
html

How can i do this.
Thanks in advance.

Accessing controls in excel using vbscript
 

With ActiveSheet.Combobox1
for i = 0 to .listcount - 1
v = .list(i)
' populate
next
End With

--
Regards,
Tom Ogilvy

"Suresh" wrote in message
...
I have an excel sheet which populates values based on a value selected in
a
combobox. I am using a vbscript code to access this excel and generate an
html page.

My requirement is to generate seperate html page based on each value in
the
excel combobox.

Using vbscript i need to write
I need to identify the combo list items.
I need to repopluate the excel for each combo values before generating the
html

How can i do this.
Thanks in advance.