any idea how to solve this?

[BewilderedSoul]

I am using the following code to prompt user to select the file that they want to open. How to prevent error message from showing when user press cancel on the open file dialog?

sub openfile()
Dim namefile as String
namefile = Application.GetOpenFilename
Workbooks.Open namefile
end sub

 

[Michael M]

DELETED...misread

 

[GTO]

Try:

If namefile = "False" Then Exit Sub

 

[Michael M]

try

Sub openfile()
Dim namefile As String
namefile = Application.GetOpenFilename
If namefile = "False" Then Exit Sub
Workbooks.Open Filename:=namefile
End Sub

****....sorry GTO....too late.