+ Reply to Thread
Results 1 to 5 of 5

how to open a specific file name

  1. #1
    Forum Contributor
    Join Date
    10-27-2010
    Location
    singapore
    MS-Off Ver
    Excel 2003
    Posts
    107

    how to open a specific file name

    Below is the codes i used to open all files type. With this codes i can open all types of files with any name. How can i modify this such that i can only open a file with specific name.
    For e.g. the codes should only allow the user to open files with the name "board", so the user can only select files such as "board.txt" or "board.jpg" or "board.xls".and so on

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: how to open a specific file name

    You could use this code:

    Please Login or Register  to view this content.
    Regards,
    Antonio

  3. #3
    Forum Contributor
    Join Date
    10-27-2010
    Location
    singapore
    MS-Off Ver
    Excel 2003
    Posts
    107

    Re: how to open a specific file name

    Thanks Antonio for your help. It worked but it ioened the file as long the file name starts with "board"
    e.g.filename such as "board 1", "board 2", "board_apple" can also be opened

    Is it possible to restrict the user by forcing him/her to select file name that is exactly "board".

  4. #4
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: how to open a specific file name

    Yes, you could use this code:
    Please Login or Register  to view this content.
    Regards,
    Antonio

  5. #5
    Forum Contributor
    Join Date
    10-27-2010
    Location
    singapore
    MS-Off Ver
    Excel 2003
    Posts
    107

    Re: how to open a specific file name

    Hi, this time it is not opening any files including files name with "board"

    I have attached a zip file consisting
    a workbook with your codes., and
    Ia sample "board" file that need to be open

    book1.zip

+ 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