select data from dropdown menu
 

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.

select data from dropdown menu
 

Can you provide the url and samples

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
oups.com...
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.

select data from dropdown menu
 

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/tradi...at_balance.asp



On Sep 15, 1:14 pm, "Don Guillett" wrote:
Can you provide the url and samples

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

oups.com...



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.- Hide quoted text -

- Show quoted text -

select data from dropdown menu
 

Try logging on first and then using your query

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
ups.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
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/tradi...at_balance.asp



On Sep 15, 1:14 pm, "Don Guillett" wrote:
Can you provide the url and samples

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

oups.com...



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.- Hide quoted text -

- Show quoted text -