Hi
I would like to import the data table from http://financials.morningstar.com/va...&culture=en-US
Specifically the table under "Valuation History INTC", excluding the graphs. I've tried web query, but I cannot grab that specific table. Is this a lot of work?
Thanks in advance for any tips.
Here is the code:-
I am writing the code here straightaway. It may have some bugs but should do the job.
Before running this code please refer.
Microsoft Microsoft Internet Controls
and
Microsoft Html object lib in the VB editor>>tools>>references
Please Login or Register to view this content.
Last edited by Vikas_Gautam; 04-25-2015 at 02:35 PM.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Now this one is more efficient than previous one. Very Fast.
Before running this code please refer.
Microsoft Microsoft Winhttp Services
and
Microsoft Html object lib in the VB editor>>tools>>references
Please Login or Register to view this content.
Vikas you are a kind and beautiful person. I am literally stunned and in tears to see thus wonderful code that you have gifted to me!
The first I could only run with admin privileges strangely on my laptop, and it didn't run on a new machine with a clean install at all which had trouble with a recent security IE patch. Figured somehow that error would cause trouble.
So the second Mozilla one should do the trick, and it is super fast!! Is there a way to shift the outer table contents easily with the inner r,c parameters?
Thank you Sir. I am indebted. This saves me countless hours and sanity after constant macro work all weekend.
Sorry, for replying late.
Actually I was in the process of learning web scrapping.
In the way, I found your question. So I had to answer.
No need to thank.
Sorry, I didn't understand your question.
Is there a way to shift the outer table contents easily with the inner r,c parameters?
Scraping a Java webpage into Excel 2013 involves a few steps:
Open Excel 2013 and create a new workbook.
Go to the "Data" tab and click on "From Web" in the "Get External Data" section.
In the "New Web Query" dialog box, enter the URL of the Java webpage you want to scrape.
The webpage will load in a new window. Use the mouse to select the data you want to scrape.
Click on the "Import" button to import the selected data into Excel.
Choose where you want to place the imported data in the workbook and click on the "OK" button.
Excel will import the data and display it in the worksheet.
Note that scraping webpages may violate the website's terms of use or even be illegal in some cases. It's important to check the website's terms of use and applicable laws before attempting to scrape any data. Additionally, make sure you have the legal right to use the data you scrape, and do not infringe on anyone's intellectual property rights.
Ok Mr "Resurrect an 8 year old thread with an irrelevant answer I got from ChatGPT".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks