Downloading database from website and automating that

[mickeystanford_alumni]

Hi gents,

Is there any VBA code to get the XLS database from this link: Total Energy Monthly Data - U.S. Energy Information Administration (EIA)

Specifically, I am trying to get the 1.1. primary energy overview dataset into an excel in my desktop called Energy_Source and Sheet called Energy.

Also, if API's are needed, could you please briefly explain the process (too much asking I know, just trying to learn about it).

Thank you so much.

 

[Kerryx]

Just download the xml file to your pc or import into power query using the link on the website https://www.eia.gov/totalenergy/data/browser/xls.php?tbl=T01.01&freq=m

 

[John_w]

You could download the XLS file using the link on the web page directly using Excel's File -> Open -> https://www.eia.gov/totalenergy/data/browser/xls.php?tbl=T01.01&freq=m

 

[mickeystanford_alumni]

Thank you both. I tried to put directly a VBA code which directly after running it, it gives you the data. But honestly it is quite efficient to do just the query.

Thank you again.