Results 1 to 2 of 2

Macro to search for specific file name

Threaded View

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Bristol
    MS-Off Ver
    Excel 2003
    Posts
    2

    Macro to search for specific file name

    Hi everyone!

    I'm new to this forum and I need your help.

    I want to create macro to serch for files with known names through folders on my computer. I'm working for valve design company. Very often I have to search multiple folders in different locations to find technical drawings I need. Usualy I have to find 17 different drawings for parts for one valve. It takes around an hour to find all the files I need.

    I've found and modify a macro which can search, list and open files with selected extension. I would like to add 17 textboxes (for each part) and use names along with the file extension to find all the drawings.

    I'm new to VB and I know only basics. I'm using excel 2013

    Sorry for my bad english.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SubFolder search but for specific file type
    By jquintana83 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-26-2014, 10:05 AM
  2. VBA to search files within a folder for a specific string and return file name
    By tjej6987 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2014, 12:41 PM
  3. [SOLVED] Macro to manually choose PDF file and save it to a specific location with specific name
    By tnuis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2014, 07:47 AM
  4. Macro to search file location for presence of a specific file
    By Student1990 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2014, 02:31 AM
  5. VBA Macro for search specific word and input specific value
    By Toton6868 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-10-2013, 07:14 AM
  6. Search folder then file for specific cells
    By MikeNZ in forum Excel General
    Replies: 8
    Last Post: 04-09-2010, 11:23 PM
  7. how do i search for a specific name in an excel file
    By cljenkins in forum Excel General
    Replies: 4
    Last Post: 12-28-2005, 08:30 PM

Tags for this Thread

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