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.

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

--
Regards,
Tom Ogilvy

"Suresh" <Suresh@discussions.microsoft.com> wrote in message
news:E88A03D8-710C-435E-9B93-F383050AE432@microsoft.com...
> 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.