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. #4
    VBAX Newbie
    Joined
    Mar 2018
    Posts
    1
    Location

    Love the code - can you help a VBA newbie with a question?

    I know this was posted some time ago, but I've tested it and it's working great.
    I'm using it to search through excel files in a SharePoint folder.
    What I need to do is loop at the strSearch for several different text strings.
    I'm not sure how to have it loop at this point. Can you help please?

    'Change as desired
        strPath = "c:\Users\My\Desktop"             '////////////////   <--- Change directory here  \\\\\\\\\\\\\\\\\\\\\\\\
        strSearch = "To"          '/////////////////    <--- Change term to search for here     \\\\\\\\\\\\\\\\\\\\\\\
    Sincerely,
    Mike
    Last edited by Aussiebear; 04-19-2023 at 04:25 AM. Reason: Added code tags

Posting Permissions

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