Hi everyone. My application does a data query on an internet site. When the internet isn't functioning, I'm getting the following error message"
runtime error
[DATAFORMAT.ERROR]
THE SERVER OR PROXY WASN'T FOUND
I would like to trap this specific error and allow the user to manually input the data and continue with the program. We lose internet access daily and it's essential that we can continue to process if the internet is down.
If the error is another error of any sort, I want to tell the user there has been an error and they need to start excel again. Very occasionally, I will get what appears to be a random error to me. It's simple enough to restart excel should this happen. I will eventually address this issue, but as a practical matter, it happens so rarely it's not worth addressing at this time. Data integrity is not an issue here. So I just want to put up a message box and tell them excel will have to be started over.
Thanks!
runtime error
[DATAFORMAT.ERROR]
THE SERVER OR PROXY WASN'T FOUND
I would like to trap this specific error and allow the user to manually input the data and continue with the program. We lose internet access daily and it's essential that we can continue to process if the internet is down.
If the error is another error of any sort, I want to tell the user there has been an error and they need to start excel again. Very occasionally, I will get what appears to be a random error to me. It's simple enough to restart excel should this happen. I will eventually address this issue, but as a practical matter, it happens so rarely it's not worth addressing at this time. Data integrity is not an issue here. So I just want to put up a message box and tell them excel will have to be started over.
Thanks!