Hi,

I would like to extract (import) data from web site and for that i
have written query. I got stuck because in the web site there are
dropdown menus. I would like to select any one from dropdown menu
e.g. if options in the dropdown are lacs, crores, millions, billions
etc. OR another dropdown where options are Cash market, Derivative
market.. How to select any one from dropdown through VBA.. since i am
newbie hence got confused.

Can anyone help me out with coding in VBA for the same.

Thank you.