Consulting

Results 1 to 3 of 3

Thread: Searching code in multiple projects/documents

  1. #1
    VBAX Regular
    Joined
    Jan 2006
    Posts
    24
    Location

    Searching code in multiple projects/documents

    Does anyone know of an easy way to search for code across multiple documents?

    I have a couple hundred coded Word templates and would like to be able to search for text strings within the VBA coding of those templates, all at once. Idealy returning a list of documents that contain the desired code.

    I know I can open the documents up and search by module or project, but I have to go into each document project and repeat the search. Windows Explore allows you to search for text within a collection of documents, but it does not extend to the VBA code.

    Alternatively, where does Word store the VBA code in a document and is there an easy way to extract it (in bulk), for indexing/analysis?

    Thanks!

  2. #2
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Are you sure it doesn't extend to VBA code?

    I've just done some tests and it found documents that I had VBA code in
    according to what I specified.

  3. #3
    VBAX Regular
    Joined
    Jan 2006
    Posts
    24
    Location
    Yes, positive. I get no hits on my searches using Explore, where the text is only in the VBA code.

    I'm using XP and running searches against Word templates.

    Can other's replicate this?

Posting Permissions

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