Dealing with datasource.error in Excel Power BI

I'm having this piece of code in Excel Power BI for an external datasource (webpage) from which I want to get some data (specific exchange rate).

Please Login or Register  to view this content.

In it self, it works. But whenever the site goes down, I'll end up with an annoying pop-up in Excel telling me some Datasource.Error occured while periodically updating my query. I'd like to get rid of that.

I'm not a programming wizard at all, just copying/pasting bits and pieces from wherever I find them on the internet, meanwhile trying to learn something.
But I think I need to handle the response code on the Web.Contents call, by adding the optional parameter [ManualStatusHandling={401,403,404}] to the call. Another option might be to put a try-construction in, although the exact status handling would be neater. Can somebody please help me out and show me what the code should look like to properly handle this (or some other) status that might occur, so it does nothing when the mentioned statusses occur and otherwise picks up the data?

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)