Forcing Excel VBA to make a request to a URL

I have some VBA code that fetches a file from a remote server to populate a list box in Excel. I am using Microsoft® Excel® 2021 MSO (Version 2304 Build 16.0.16327.20200) 64-bit  The VBA code that I...