Importing data from a website into Excel
I'd like to write a VBA code to import data from the Morningstar website into an Excel template. The data is on an investment readout page where there are 3 tables of data that I would like to import onto an Excel spreadsheet instead of having to type them in each by hand. Is there a way to do this? I would have to go to the website first and load the portfolio information and then, once the web browser is on the specified page, I would click run and the VBA code would analyze the current page. Thanks for your help.
