Consulting

Results 1 to 5 of 5

Thread: vba command import data from web page

  1. #1

    vba command import data from web page

    I am trying to import data from a web page into my Excel file.
    The page has the standing of the sport teams.
    The page has many lines and many rows.
    I need all the lines with the name of the team but only need 4 or 5 of the rows; name of the team, Win, Lost and Tie.
    I have tried different commands without success.
    Your help will be appreciated,
    Rick

  2. #2
    what is the URL?

  3. #3
    it is the site of the National Football League, Standing, League, 2021, Regular

  4. #4
    you can use Power Query in Excel.
    download the workbook.
    https://www.dropbox.com/scl/fi/457e8...k3hr7mhj66p3zy

  5. #5
    Many thanks
    I will try it.

Tags for this Thread

Posting Permissions

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