Results 1 to 18 of 18

Thread: Need List of Files Containing Specific Text

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-06-2019, 07:26 AM #17
    jigneshwaghe
    jigneshwaghe is offline
    VBAX Newbie
    Joined
    Oct 2019
    Posts
    1
    Location
    Hi, The code in Search All Files For Term.xlsm is working great. however I have similar request as one of the user asked..is it possible to
    1) Search through Cells from A2 to A1500 one by one & 2) Save file names in individual sheets with sheet name same as cell values (A2 to A1500 - already present in workbook) at cell address specified in column B (B2 to B1500)
    Capture.JPG
    Snapshot attached - example search for #cmsga (text in b2) in list of text files at D:\textfiles and save file names at location specified in C2 of sheet with same name as B2

    Thanks
    Jignesh
    Last edited by jigneshwaghe; 10-06-2019 at 07:30 AM. Reason: Including snapshot
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules