I use a web query in excel which extracts data from a URL and displays it in worksheet. Whenever the remote website is down or slow and the web query fails, the error message displays the URL along with all the parameters.
However, I don't want to display the URL. I'd rather like a custom message displaying the name of the connection or only the URL but not the connection parameters or suppress the message altogether.
What is the solution? At present I am not using any Macro / VBA but I am open to using it, if required.
Thanks in Advance for any help.