hide error pop up

[Undo]

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

[vba_php]

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.

[Undo]

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

[vba_php]

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.

[Undo]

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?

[vba_php]

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/

[Undo]

can I put

Application.DisplayAlerts = False

in query advance editor?

[vba_php]

in query advance editor?

what does that mean? excel has no such named feature or tool.

[vba_php]

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.