How about:

Sub dural()
Filename = Application.GetOpenFilename()
If Filename = False Then
Exit Sub
End If
MsgBox (Filename)
End Sub

--
Gary''s Student - gsnu200901


"AG" wrote:

Hi,

This should be fairly simple for a lot of you but I am struggling with
it. I have a macro that opens up a dialog box to allow users open the
input data file to be processed using macro. Many a times users click
cancel instead of opening the file and in that case I get a run time
error.

What is want is when the users cancel it should just give them a
message and macro should end while if they opened the input file then
the rest of the macro should run.
Can someone help me with this? Thanks.

- AG