Exit Sub when File Open Dialogbox is cancelled

  • Thread starter Thread starter AG
  • Start date Start date
A

AG

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
 
How about:

Sub dural()
Filename = Application.GetOpenFilename()
If Filename = False Then
Exit Sub
End If
MsgBox (Filename)
End Sub
 
Hi,
thanks for your help on this. The first part is working fine now,that
is, if the user cancels then it stops but I had added the else part in
there which does not execute at all. Not sure what is the reason.
 
Got the issue resolved. Actually I just needed to add a statement to
open the workbook if the user selected one. It works perfectly now.
Thanks for the help.
 
Back
Top