+ Reply to Thread
Results 1 to 2 of 2

Use Excel as a list to search files for string

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-01-2009
    Location
    Maine, USA
    MS-Off Ver
    Excel 2016
    Posts
    161

    Use Excel as a list to search files for string

    I have an Excel file with usernames in column B. I would like to start on B2 (B1 is the header), and search all files in a directory for that name (including all sub directories and files). If that name does not exist, then make the font face red. I'd like for it to keep searching until it reaches the end of the file.

    Any help would be greatly appreciated.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,719

    Re: Use Excel as a list to search files for string

    This link should help you get started.

    http://stackoverflow.com/questions/2...ple-subfolders
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search for a string on all excel files inside a ZIp folder
    By Moreno20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2014, 03:45 PM
  2. Replies: 0
    Last Post: 01-11-2013, 12:05 AM
  3. Want to search for string in list of files in a folder
    By DeepthiReddy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2012, 03:21 AM
  4. Search for a string in multiple excel files with multiple sheets
    By ghermanu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2012, 05:46 PM
  5. Case insensitive search for string within folder of excel files
    By vba_novice in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-22-2011, 11:21 PM
  6. Search and Copy files from a list of file names excel vba programming
    By aashishnawal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2010, 09:27 AM
  7. Search files in folder based on search string
    By djvice in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-22-2008, 01:12 AM
  8. [SOLVED] How do I search a text string in many excel worksheets (files)?
    By TC628 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2006, 08:15 PM

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