Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a problem with the following subroutine. The files that it opens are located in one of two locations, and it accomplishes this regardless of what folder the file is located in. The problem is that it pauses execution everytime any line in that particular subroutine gets run. What's more confusing is that before, it worked perfectly, and seemingly without any changes, suddenly this bug cropped up. Sub OpenMatFile(FileName As String) On Error Resume Next Workbooks.Open MatPath & FileName, UpdateLinks:=False, ReadOnly:=True If Err.Number < 0 Then Workbooks.Open MatPath & "2009 Material Archives\" & FileName, UpdateLinks:=False, ReadOnly:=True End If End Sub -- Burnnie Holliday |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
First Error works but Subsequent Error Handling Does Not | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Set Error handling INSIDE error-trap | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error handling with a handling routine | Excel Programming |