PDA

View Full Version : vba command import data from web page



RickGauthier
10-25-2021, 08:56 AM
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

arnelgp
10-25-2021, 06:41 PM
what is the URL?

RickGauthier
10-26-2021, 12:23 PM
it is the site of the National Football League, Standing, League, 2021, Regular

arnelgp
10-26-2021, 09:22 PM
you can use Power Query in Excel.
download the workbook.
https://www.dropbox.com/scl/fi/457e81bzcjum2knmdm0ug/nfg_regular.xlsx?dl=0&rlkey=2qsmfxgz7u0k3hr7mhj66p3zy

RickGauthier
10-27-2021, 06:16 AM
Many thanks
I will try it.