According to the site they are performing upgrades this month:

February 2024: The Pacific Exchange Rate Service is being upgraded. We apologize for any disruptions.
The data services are fully operational, but ancillary web pages are still undergoing revisions.

The Sauder site also says that they pull their data from the Bank of Canada site and looking there it appears that you can pull the rates in a few different formats:

https://www.bankofcanada.ca/rates/exchange/daily-exchange-rates/

Plus they talk about a Valet API for integrating with applications.

And Tairox has a utility that can facilitate much of this for your client: www.tairox.com/download-rates-for-sage-300-erp-accpac.html

According to the site they are performing upgrades this month:

February 2024: The Pacific Exchange Rate Service is being upgraded. We apologize for any disruptions.
The data services are fully operational, but ancillary web pages are still undergoing revisions.

The Sauder site also says that they pull their data from the Bank of Canada site and looking there it appears that you can pull the rates in a few different formats:

https://www.bankofcanada.ca/rates/exchange/daily-exchange-rates/

Plus they talk about a Valet API for integrating with applications.

And Tairox has a utility that can facilitate much of this for your client: www.tairox.com/download-rates-for-sage-300-erp-accpac.html

Thanks for the quick reply. I'm aware of the Tairox product. I'd rather just have the macro work without having to sell a new product. I messed around with some of the Bank of Canada url's but can't get it to work in the macro. I think we'll wait and see if Sauder's updates break the macro functionality once they're completed.