Consulting

Results 1 to 2 of 2

Thread: Importing data from a website into Excel

  1. #1
    VBAX Regular
    Joined
    Mar 2013
    Posts
    46
    Location

    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.

  2. #2
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,661
    p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •