Hi there,
I've got a macro which is designed to activate or open a wb.
The "Open" code is performed by an error handler.
However, if an error occurs here how can I handle it?
I've only recently started with error handling so please forgive my lack of knowledge
Sub Activate_or_Open_pINFO_2()
Dim sName As String
Dim OpenPATH
sName = Range("C3")
OpenPATH = ThisWorkbook.Path
On Error GoTo ErrorHandler
Workbooks(sName & ".xlsm").Activate
Exit Sub
ErrorHandler:
On Error GoTo err1
Workbooks.Open FileName:=OpenPATH & "\" & sName & ".xlsm", _
UpdateLinks:=True
Exit Sub
err1:
MsgBox "The property info sheet is not available. It may have been deleted or moved from the file directory."
End Sub
Bookmarks