I ask user to choose a file, then I use this file to do sth. But if h
cancels, I want to stop my macro.

For example,

Code
-------------------
Dim s_file As String

s_file = Application.GetOpenFilename("Fichiers office, *.xls")
If s_file = "False" Then
' I want stop my macro here
End If
' ..
-------------------


Regards

--
Guendal

-----------------------------------------------------------------------
Guendalf's Profile: http://www.excelforum.com/member.php...fo&userid=2448
View this thread: http://www.excelforum.com/showthread.php?threadid=38086

Use the statement "Exit Sub" if you are in a sub, or "Exit Function" i
you are in a function

--
JP
-----------------------------------------------------------------------
JPW's Profile: http://www.excelforum.com/member.php...fo&userid=2448
View this thread: http://www.excelforum.com/showthread.php?threadid=38086

If s_file = "False" Then
END
End I

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=38086

Note that using End stops everything immediately with no termination events.
Global variables are zeroed for example. This may be what you want, but
most don't.

--
Regards,
Tom Ogilvy


"anilsolipuram"
wrote in message
news:anilsolipuram.1qzc75_1119363209.066@excelforu m-nospam.com...

If s_file = "False" Then
END
End If


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile:
http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=380861

END

Be careful using the End statement. It does indeed stop VBA code
execution, but it also clears all global variables, resetting
them to their uninitialized default values. This may cause
problems with other procedures.

In general, Exit Sub or Exit Function is the better solution.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"anilsolipuram"
wrote
in message
news:anilsolipuram.1qzc75_1119363209.066@excelforu m-nospam.com...

If s_file = "False" Then
END
End If


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile:
http://www.excelforum.com/member.php...o&userid=16271
View this thread:
http://www.excelforum.com/showthread...hreadid=380861

anilsolipuram Wrote:
If s_file = "False" Then
END
End If

It's what I was looking for. :)
Thanks.


--
Guendalf


------------------------------------------------------------------------
Guendalf's Profile: http://www.excelforum.com/member.php...o&userid=24480
View this thread: http://www.excelforum.com/showthread...hreadid=380861