select data from dropdown menu

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

khushi.kotian@gmail.com - 15 Sep 2007 12:35 GMT

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.

Reply to this Message

Don Guillett - 15 Sep 2007 13:14 GMT

Can you provide the url and samples

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hi,
>
[quoted text clipped - 9 lines]
>
> Thank you.

Reply to this Message

khushi.kotian@gmail.com - 16 Sep 2007 14:22 GMT

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

> Can you provide the url and samples
>
[quoted text clipped - 21 lines]
>
> - Show quoted text -

Reply to this Message

Don Guillett - 16 Sep 2007 15:11 GMT

Try logging on first and then using your query

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> 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
[quoted text clipped - 31 lines]
>>
>> - Show quoted text -

Reply to this Message