+ Reply to Thread
Results 1 to 4 of 4

Attempt to open file on error popup

  1. #1
    Forum Contributor
    Join Date
    04-03-2009
    Location
    USA, California
    MS-Off Ver
    Excel 2007
    Posts
    385

    Attempt to open file on error popup

    I need a macro that will attempt to open a file in a specified directory. If the file can not be found I want a file explorer window to pop up so that the user could navigate to and select the file. Upon choosing said file the macro would open that file instead.

    Thanks in advance.
    Last edited by randell.graybill; 10-08-2010 at 08:37 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Attempt to open file on error popup

    Excel has the dialog already built in.

    In your immediate window enter
    Please Login or Register  to view this content.
    This one line of code gets you real close to your needs.

  3. #3
    Forum Contributor
    Join Date
    04-03-2009
    Location
    USA, California
    MS-Off Ver
    Excel 2007
    Posts
    385

    Re: Attempt to open file on error popup

    Figured it out. Not sure if there is a better way to do this but this works.

    Please Login or Register  to view this content.
    Last edited by randell.graybill; 10-08-2010 at 08:21 PM.

  4. #4
    Forum Contributor
    Join Date
    04-03-2009
    Location
    USA, California
    MS-Off Ver
    Excel 2007
    Posts
    385

    Re: Attempt to open file on error popup

    Solution to set directory

    Please Login or Register  to view this content.
    Last edited by randell.graybill; 10-08-2010 at 08:37 PM.

+ 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