PDA

View Full Version : Importing data from a website into Excel



bopha99
07-15-2013, 10:40 PM
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.

p45cal
07-16-2013, 12:16 AM
check out:
http://finance.groups.yahoo.com/group/smf_addin/
http://finance.groups.yahoo.com/group/smf_addin/message/19776
http://finance.groups.yahoo.com/group/smf_addin/message/22970