Get Table Data from Internet into Excel (using VBA)

I need a Excel based Visual Basic code written to get the data into Excel. I'd like the ability to enter a stock symbol in a cell (like DUK or CSCO) and have VBA pull back all the option data available.

The two websites that have the easiest and most complete data are:

[login to view URL] (multiple pages of data)

[login to view URL] (1 page of data, but the expiration drop down needs to be changed to ALL)

See file where I show what the downloaded data should look like from either site.

Skills: Excel, Visual Basic

See more: feed data internet excel, paste data internet excel, extract image excel using vba, automatically pull data from website into excel vba, excel vba html table import, vba import table from website, scraping web page data automatically with excel vba, excel vba pull data from a website table, excel vba scrape table from website, vba web query, how to pull data from a website into excel macro, uninstall addins excel using vba, import mpp file excel using vba, data migration excel using, create lotto excel using vba, import project data excel using vba, data conversion excel acccess vba scripts, copy internet explorer data excel using vba, as400 excel using vba, read unicode excel using vba

About the Employer:
( 2 reviews ) EAGAN, United States

Project ID: #19748280

Awarded to:


Hello I have several years of experience with both Visual Basic and VBA Also, I have strong experience with Web Scraping with VBA I believe there is couple of hours of pure working time.

$21 USD in 1 day
(337 Reviews)

7 freelancers are bidding on average $19 for this job


Good Day. Hi Dear. -----Please look for my description-------- I read your description carefully and am very interesting in your project. I can start right now and can do it perfectly. If you hire me, I will do my best More

$20 USD in 7 days
(10 Reviews)

Hello there I am a VBA expert. I will write the code. If you want to done your task perfectly and accurately then please contact me. Hope to hear from you. Thanks.

$10 USD in 1 day
(8 Reviews)

I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data extracting, data scraping, virtual assistant. I hope your kind response.

$15 USD in 1 day
(0 Reviews)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th More

$20 USD in 7 days
(0 Reviews)

I do believe that I am the most suitable person for this Job. Given my years experience in Data Entry and Information Technology. I am well equip to input accurate information in a timely manner. I would be more than h More

$20 USD in 7 days
(0 Reviews)

I am Neha C from India. I am a Web Developer and have 5+ experience in VB,ASP.Net,Excel,SQL,Oracle. I like doing challenging work and I always complete my commitments.I have hands on experience on excel macros and V More

$30 USD in 2 days
(0 Reviews)