Error Handling for not finding network address? ...ignore without popup.

[chuggins143]

Hello all,

I have a macro that will go out to a text file on our server and retrieve some data... obviously, it works fine when I'm connected, but if I lose connection with the server then I get a window that says... "Sorry, we couldn't find 'file address'. Is it possible it was moved, renamed, or deleted?" I'd like to automate the sheet so that it'll run the macro every few min, but ignore the error if it loses connection. Anyone have a suggestion on how to have my code ignore this error?

TIA,

Chad

 

[jsb1921]

On error resume next
----open the file --
if err.number <> 0 then
   exit sub
else
    -- process your task  --
end if

 

[chuggins143]

JSB, Thank you for the response!

I did have to add the following at the top of my sub to get the popup to stop too...

Application.DisplayAlerts = False

The combination of these seems to have stopped the annoying popup I was getting... the first time it goes and tries to find it takes a few seconds, but once the computer realizes that it can't get to the server then it's virtually instantaneous.

Thanks!

Chad