+ Reply to Thread
Results 1 to 3 of 3

Search a group of excel files for info?

  1. #1
    Registered User
    Join Date
    07-13-2010
    Location
    KY
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Search a group of excel files for info?

    I have around 160 excel files with between 20-60 thousand rows of data in each of them.

    What I am wanting to do is search all 160 files for a specific word...I really don't care where it is inside the file as long as I can get a total of how many times it shows up in each file.

    I really just need a total count of how many times the word shows up or an outputed list would be better.

    Any way this can be done?

    pmw
    Last edited by pimpmyworksheet; 07-16-2010 at 11:59 AM.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Search a group of excel files for info?

    Supposing:
    - the 160 files are xls files in directory "C:\wordcount"
    - the word you are looking for doesn't appeat twice in a cell.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-13-2010
    Location
    KY
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Search a group of excel files for info?

    Perfect Thank You Snb!

+ 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