If statement does not give desired results.
Posted by MILAN on September 24, 2001 9:40 AM
I need this if statement to exit the macro and not go to the VBA editor or
offer the option to debug if the user choosed cancel instead of open in the
file open box.
fileToOpen = Application.GetOpenFilename("text files (*.txt),*.txt")
If fileToOpen <> False Then
MsgBox "Open" & fileToOpen
When cancel is chosen this error message appears.
"Runtime error 1004, False.xls could not be found...."