Error Handling

[rossbritton26]

Hi,

I have some code with opens a file one at a time from a list and this works fine until the file in the list cannot be found in the already specified location.

My only problem is what the code does when the file cannot be found.
Currently, Excel displays a error message and then gives me the option to End or Debug, however as the list of files can be quite large I would just like to skip to "Next k" and resume running the code as if nothing as happened.

I have tried many combinations of onerror etc. but can't seem to crack it,

any ideas?
Ross.

 

[VoG]

Maybe like this

On Error Resume Next
'
'try to open the file
'
On Error GoTo 0

 

[cova]

OnError Resume Next would be my choice, but without seeing the code I couldnt say it would work for sure

 

[RoryA]

It would be better to test for its existence before trying to open it:

If Dir("your file path") <> "" Then
' process file code here
End If

for example.

 

[rossbritton26]

Rory,

That worked brilliantly thank you very much.

I have also implemented the other answers thank you and will use them again in the future.

Ross