LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default how to stop a macro


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Stop LMP Excel Worksheet Functions 3 April 28th 08 07:33 PM
Stop running a macro in the middle of a macro gmunro Excel Programming 3 June 9th 05 06:00 PM
Macro: With Stop it works. Without Stop it doesn't. Don Wiss Excel Programming 2 October 12th 04 10:49 AM
Start Macro / Stop Macro / Restart Macro Pete[_13_] Excel Programming 2 November 21st 03 05:04 PM
How do I stop a macro Steve[_41_] Excel Programming 2 September 23rd 03 03:54 PM


All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"