html dropdown lists with VBA

Hi everybody,

I am working on a macro which goes to a specific url then copy and paste the page on an excel spreadsheet.
It's all right until I copy and paste the whole page, but now I'd need to select a given value on a dropdown list on that webpage in order to get what I exactly want.

Would you please help me in this?

The webpage has nine dropdown lists and I need to select the value of last one.
I'm not good in HTML but I think the following string of the code defines the droplist I need:
<select name ="calendar"> (there are indeed nine of them)
and this following string should say the value needed to pilot the list and what it shows
<select value ="7">ABCD</option>

My code is so far like this:

URL = "http://abcdefgeh.report.php"
ret = Shell("rundll32.exe url.dll,FileProtocolHandler " & URL)

Set ie = CreateObject("InternetExplorer.Application")

ie.navigate URL
Do While ie.ReadyState <> 4
DoEvents
Loop
ie.ExecWB 17, 0
ie.ExecWB 12, 2

I totally ignore how to write the rest of the code that might select the list choosing the given value...
I'd appreciate any help

thanks a lot

guys please...any suggestion?

Hello gip.pisano, do you still need this code to be written? I can try to solve it but i will not try to do it if you already have found a solution. Regards.