Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
How do you use a dropdown menu to enter data in mult. cells exce? | Excel Worksheet Functions | |||
In Excel how do I set up the list from the Data dropdown menu? | Excel Discussion (Misc queries) | |||
I can not find the list command from the data dropdown menu? | Excel Worksheet Functions | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions |