+ Reply to Thread
Results 1 to 5 of 5

I need help with Application.GetOpenFileName

  1. 10-11-2013, 10:07 PM #1
    venkatpvc
    venkatpvc is offline
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    I need help with Application.GetOpenFileName

    Hello Everybody,

    Thank you everybody in this forum, for giving us chance to learn something.

    and I have this below code everything working perfectly for me, but I need help with if user dont select any file. it shows error message. how can I avoid this error message.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 10-11-2013, 10:52 PM #2
    fredlo2010
    fredlo2010 is offline
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: I need help with Application.GetOpenFileName

    This should take care of it:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 10-12-2013, 09:29 AM #3
    venkatpvc
    venkatpvc is offline
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: I need help with Application.GetOpenFileName

    Thank You Fred,
    For your time and reply................
    Reply With QuoteRegister To Reply
  4. 10-12-2013, 09:40 AM #4
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: I need help with Application.GetOpenFileName

    Hi,

    Or another way which avoids having to use ON Error - just the relevant bit for your code

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  5. 10-12-2013, 10:00 AM #5
    venkatpvc
    venkatpvc is offline
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: I need help with Application.GetOpenFileName

    This is good idea to learn,
    Thank for your add Richard
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Application.GetOpenFilename
    By Screamtruth in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-06-2010, 02:49 PM
  2. Application.GetOpenFileName
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-18-2006, 07:40 PM
  3. [SOLVED] [SOLVED] Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen)
    By Paul Martin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2005, 12:05 PM
  4. [SOLVED] Application.GetOpenFilename
    By Nigel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2005, 12:06 PM
  5. Application.GetOpenFilename
    By Greg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2005, 10:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1