+ Reply to Thread
Results 1 to 4 of 4

Finding a specific Excel file Name from a folder through VBA

  1. #1
    Forum Contributor daksh1981's Avatar
    Join Date
    04-15-2009
    Location
    India
    MS-Off Ver
    2003 & 2007
    Posts
    110

    Thumbs up Finding a specific Excel file Name from a folder through VBA

    I need your help on finding a specific file from a folder through VBA. For example I want to find an Excel file which is starting with name like “System Downtime Details” usually this file has date also along with this name like System Downtime Details- Jun 2010 I just want to find the System Downtime Details files without looking at the date associated.

    Hope I have clearly explained my problem. Please let me know in case any further details are required on this.
    Last edited by daksh1981; 06-30-2010 at 06:21 AM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Finding a specific Excel file Name from a folder through VBA

    hi daksh1981
    You could modify this code from Julttta Korol for 2003 or for 2007
    royUK has a solution on his site
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Contributor daksh1981's Avatar
    Join Date
    04-15-2009
    Location
    India
    MS-Off Ver
    2003 & 2007
    Posts
    110

    Re: Finding a specific Excel file Name from a folder through VBA

    Hi Pike,

    Thanks a ton for the help. Its working. God bless you.

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Finding a specific Excel file Name from a folder through VBA

    no, Thank you for taking the time to mark the post solve .

+ 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