Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Search for Key Word in Module (XP)

    Is it possible to search on a key word in a VBA module? I tried using the Windows Explorer search feature and it's advance search features. There is a dropdown to search on modules but it does not return a file name based on a known keyword I have in a file. The file is saved so that is not the problem.

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Search for Key Word in Module (XP)

    No, the built-in search apparently doesn't find text in modules. Have you tried Windows Desktop Search or Google Desktop Search (or similar)?

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search for Key Word in Module (XP)

    Hans,

    When I have an opportunity, I'll have to try the search features of windows and google desktop search.

    If someone is already using one of these, I would appreciate hearing back.

    Regards,
    John

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search for Key Word in Module (XP)

    I tried the Windows Desktop Search program and it does not search the vba modules.

    John

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Search for Key Word in Module (XP)

    That's too bad. Try the free utility Agent Ransack - according to comments in Daily Dose of Excel - Searching VBA Projects, it is able to find text in VBA code.

Posting Permissions

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