Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the following to retreive the name of a file that i wish to open.
If i select 'Cancel' rather than a file name and 'Open', i would receive a Run-time error 1004. I am handling this potential error using the ErrorClose routine to allow me to 'Retry'. If i select the option to retry and then elect not to open a file for a second time i receive the Run-time error 1004 message which is not handled by the ErrorClose. Why would the error be handled as expected on the first pass but not on the second? Thanks Step1: RawDataFileInfo = "Excel Files (*.xls),*.xls," & _ "Excel Files (*.xlsx),*.xlxs" RawDataFilterIndex = 1 RawDataTitle = "Select Raw Data File to Import" RawDataFileName = Application.GetOpenFilename(RawDataFileInfo, RawDataFilterIndex, RawDataTitle) On Error GoTo ErrorClose "Rest of Code" ............................. Exit Sub ErrorClose: If Err.Number = 1004 Then ErrMsg = "You must select an Outstanding Stock Order to import" & vbNewLine & vbNewLine ErrReply = MsgBox(ErrMsg, vbExclamation + vbRetryCancel, "Invalid Action") If ErrReply = vbRetry Then GoTo Step1 Else Application.ActiveWorkbook.Close End If End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Run time error 1004 General ODCB Error | Excel Programming |