Hello
I am getting data from web in excel and refresh every few mins
sometime I lose net connection and this error exist, I dont want show this error, excel has this settings to hide the error ?
thanks
Hello
I am getting data from web in excel and refresh every few mins
sometime I lose net connection and this error exist, I dont want show this error, excel has this settings to hide the error ?
thanks
Last edited by Undo; 09-29-2020 at 06:23 PM.
if you're doing it through the interface and not with code, I doubt you can stop it. to prevent a connection loss, try hardwiring your machines to the internet via an ethernet cable and/or usbc cords.
its not about net problem, I dont want to show the error, if i can do it eith vba its oky.. without app run on time line, because its keep macro running all time
it would make perfect sense to me that this error is built into the feature that you are using to create and maintain that connection you speak of. thus, preventing it from popping up would probably involve delving into to the ''C'' source code that was written to create Excel itself. and obviously that would be a waste of time, even if you could do it.
that's my guess anyway. I could be wrong.
thats mean no option to hide this error from excel options
but is there any vba code to hide all excel errors?
like sub before error
app error hide
end sub
is there any code?
yes there is, and it's very simple:
https://docs.microsoft.com/en-us/off....displayalerts
that probably doesn't apply to error dialogs though. see these for any ideas:
https://www.google.com/search?q=exce...error+messages
https://www.google.com/search?q=exce...+notifications
https://www.excely.com/excel-vba/dis...messages.shtml
https://www.mrexcel.com/board/thread...ssages.380936/
can I put
Application.DisplayAlerts = False
in query advance editor?
and the answer is no. that's VBA code and it only runs from one place as far as I know. putting it anywhere else in excel wouldn't make any sense.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks