Hi all,

I am trying to connect an excel sheet with the following webpage (can't paste the URL since I am new in the forum):
Bank of Canada website >> Home >> Statistics >> Exchange Rates >> Daily Rates

So my initial logic was to go to the Data tab > New Query > From Other Sources > From Web. I input the URL then select only the "Table 0" and Load the data in my existing Worksheet.

The problem is that tomorrow, the date will change in the website and the data won't update in my excel sheet. I am not sure why...

Anyone?

Thank you in advance!