VBA to Download, Extract and Import Zip File to Ex

Question

I have a simple link, www.example.com/file.zip. It's a public server and requires no login.

The link is to a zip file. The zip file contains a tab-delimited text file (20MB).

Is there an all-in-one code to download the zip file to a temp folder...extract the text file...and import its data to an Excel worksheet?

Each run of the macro would overwrite the previous data with new data.

I tried to apply the solution from another post, but I can't get it to work. The answer to the other post involved unzipping a csv file and saving it as a text file. My zipped file already contains a text file.

I'd appreciate any help.