Select Option from Web-based Database drop down list through VBA code into excel sheet

[harrisont9]

Hello,

I have an online database that I need to access data from. I've gotten as far as logging in and I'm at the page where I need to select the type of report I need. I would select if from a drop down list that contains 5 selections for different types of reports. I've tried using Browser.Document.Form(0).I<wbr style="font-size: 14px; font-family: 'Open Sans', sans-serif; line-height: 22px;">tem("Nameo<wbr style="font-size: 14px; font-family: 'Open Sans', sans-serif; line-height: 22px;">ftheDropDo<wbr style="font-size: 14px; font-family: 'Open Sans', sans-serif; line-height: 22px;">wnField").<wbr style="font-size: 14px; font-family: 'Open Sans', sans-serif; line-height: 22px;">Value = 5 (I've also used the name of the option and it didn't work either).

Any idea how else I can approach this?

Thanks,