select data from dropdown menu

[khushi.kotian]

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.

 

[Don Guillett]

Can you provide the url and samples

 

[khushi.kotian]

The site i was specifying is a private domain and you may not access
it. Can you provide me a code for picking up data from dropdown menu
and other sample files.

I got one more site from where i am trying to get data through web
query by writing a macro. I get a message "unable to open.... cannot
download data you have requested.

https://secure.icicidirect.com/trading/equity/trading_demat_balance.asp

 

[Don Guillett]

Try logging on first and then using your query