+ Reply to Thread
Results 1 to 3 of 3

Abort Options for Application.Filedialog

  1. #1
    Registered User
    Join Date
    06-10-2009
    Location
    Germany
    MS-Off Ver
    Excel 2003
    Posts
    46

    Abort Options for Application.Filedialog

    Hi,

    I am using application.FileDialog to make the user select a file, when clicking a button. Now, I have tested, what happens, when I click on "Abort", instead of selecting a file and clicking "OK". An error message appears, because no file is selected.
    So my question is: How do I state in my code, what is supposed to happen, when the User Clicks on "abort" (I want the whole Sub to be aborted in this case)

    Thanks in advance!
    Last edited by RoyMakaay1985; 09-14-2009 at 08:18 AM.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: Abort Options for Application.Filedialog

    Good morning RoyMakaay1985

    You are better off not using the FileDialog. If you are getting a filename to open a file use :
    Please Login or Register  to view this content.
    If you are using a filename to save a file use :
    Please Login or Register  to view this content.
    These are both comprehensively covered in the help files.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    06-10-2009
    Location
    Germany
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: Abort Options for Application.Filedialog

    Ok, thanks. What's worse with FileDialog? I've used it so far and it seems fine to me..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1