finding documents with macro

[ykffc]

I wrote a useful macro in one document months ago. Now I forget what and
where that document is. There are nearly 1000 word documents in my disk but
probably only a few contain macro. If there is a way for me to locate all
documents containing a macro, this solves my problem.

 

[Helmut Weber]

Hi,

open each document and check whether it contains projects.
By the way, doesn't work with me, as I get the message, that
the programmatic access is not trusted.

But a very cheap workaraound with limited guarantee could
be to use the explorer and search for documents (*.doc)
that contain "activedocument" or other keywords.
You might have to use several runs and several keywords,
as e.g. "end sub" doesn't give the expected results,
whereas "activedocument" has worked reasonably well.

Greetings from Bavaria, Germany

Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word XP, Win 98
http://word.mvps.org/
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org