Greetings,

I am importing am .xlsx table into my Excel workbook from an external website address. I am encountering a problem whereby the table that is imported only has the title of the columns, and no actual data undearneath. This means that a file is imported successfully, but the file only contains the titles of the columns.

If I type the URL into a web browser I am able to download the 46.8kb file, which is complete and correct.
If I run a macro to import the file into the same directory as the worksheet, the file is incomplete (only the column heads are displayed) and is only 7kb large.

Perhaps it has something to do with the fact that the URL (which is fixed) redirects to an updating excel file name (every 5 minutes or so)? This is what I desire, but maybe there is a conflict there which I am not aware of? Any help would be appreciated. Thank you!