Closed Thread
Results 1 to 2 of 2

Open unopened file

  1. #1
    Registered User
    Join Date
    05-01-2008
    Posts
    17

    Open unopened file

    At a certain stage, my program prompts user to open file "FileToOpen" where "FileToOpen" is a string variable assigned to the name of a certain file. In order to get to this point, I use the command: FileToOpen = Application.GetOpenFilename(<various filters>)

    If FileToOpen is already open, I get a system alert. Rather than suppress the alert, I want my program to do something like this:
    Last edited by emjbee; 07-24-2011 at 08:37 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Open unopened file

    Please close this thread or mark it as solved because you have created a more complete version later (to which I have replied).

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


Closed 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