Consulting

Results 1 to 3 of 3

Thread: Finding words in any workbook, worksheet and cell located

  1. #1
    VBAX Tutor
    Joined
    Sep 2012
    Location
    London
    Posts
    237
    Location

    Finding words in any workbook, worksheet and cell located

    Hello to all the great minds!I have the following query after a long search found some things, but not exactly what I need. I have 25 workbooks with worksheets 8-10. The tables are all quite large. So I found a few macros that do not help me to get the following:For example: open excel spreadsheet with macro example (book1) and a button to retrieve it (activated) - This workbook is the folder with all the other workbooks, start looking for the word "cucumber" and starts the macro to search all workbooks, worksheets and cells. Then in (book1) as in column A:A to I display exactly what workbook and worksheet which cell is the word or words.
    Example:
    [vba]C:\Users\Nevi_\Desktop\trii\[Book1.xls]Sheet1Book4455.xls
    Sheet8;E34;G2;B12
    Sheet2;A2;b23;AC98
    Book12.xls
    Which Sheet;Which Cells
    Which Sheet;Which Cells
    dasds.xls
    Which Sheet;Which Cells
    Which Sheet;Which Cells
    Book124554.xls
    Which Sheet;Which Cells
    Which Sheet;Which Cells
    Bookvsdsdsd.xls
    Which Sheet;Which Cells
    Which Sheet;Which Cells
    Which Sheet;Which Cells
    Which Sheet;Which Cells
    Which Sheet;Which Cells
    Which Sheet;Which Cells
    Which Sheet;Which Cell
    scucu.xls
    Which Sheet;Which Cells
    Which Sheet;Which Cells
    and next one
    and next one
    and next one
    and next one[/vba]

  2. #2
    If you open all workbooks, you could use my Flexfind utility to do this, it has a report button that comes close to what you describe:
    www.jkp-ads.com/officemarketplaceff-en.asp
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  3. #3
    VBAX Tutor
    Joined
    Sep 2012
    Location
    London
    Posts
    237
    Location
    Thanks a lot buddy.
    But I have one question:
    However, we want to make a macro for this task, because I find too many articles, but always somewhere something is missing and I had to make a special case.
    Thank you so much once more.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •