Hi Guys,
I am trying to get data from this site in excel. I need to select options from drop down menu (like bank name, balance sheet and date).
Any help will be greatly appreciated.
Thanks.
Hi Guys,
I am trying to get data from this site in excel. I need to select options from drop down menu (like bank name, balance sheet and date).
Any help will be greatly appreciated.
Thanks.
Anybody please help.
If you go to the website & open one of the dropdown boxes. Move your cursor down into the box. Right click and select "This frame" and "this frame source". You can then see all the contents of the list, with leading and trailing data, like this:
<option value="AA">Canadian Imperial Bank of Commerce</option>
You can then extract that part of the string you want by using:
Formula:Please Login or Register to view this content.
There may be easier ways, but this works
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Glenn,
Thanks for replying. The thing is that i want to create macro which will select the options like bank name and date and then extract data into excel sheet. Here is what i came up to but this code is not working. I am pretty new to VBA so i am not sue what is wrong.
Please Login or Register to view this content.
VBA is a dark art. I'm out... Anyone else want to take over?
Any VBA guru here. Please help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks