IfError when path to another workbook not available

[pltom55]

Hi,
So i have a macro that imports one sheet from several workbooks.
Sometimes I write the directory path incorrectly to the file and a debug/error popup appears and halts the process. At this point I correct the path and run the macro again.

Is there a way i can add some code that:
If workbook path is not found then
paste bad link in cells (blah blah)


I found the iferror function, but i don't see how it would apply in this scenario.
Does anyone have any suggestions on this?

Thanks in advance,

Tom

 

[EuroSong]

Try this:

Dim FilePath as String
FilePath="xxxx" ' xxxx=file including whole path
If Len(Dir(FilePath)) = 0 Then
    Debug.print FilePath & " does not exist!"
Else
    ' The file does exist in the specified path. Do your stuff
End If

Debug.print will output to the Immediate window in VBA (Ctrl+G to view).