Finding properties of a macro in code

[Vilem Sova]

I've been building a little utility MDB that will search & find all
instances of a search word within an MDB file. This is so that I can find
all references/uses of a table name, field name, query etc.

All's well so far, but I've got stuck with searching in the Macros. I've
tried the Containers ("Scripts") collection and Document collection/objects,
and can see some properties relating to the macros, but can't find the
property that gives me the executed text for the macro (so that I can find
instances of the search text).

Am I looking in the right place?

Thanks
Vilem Sova

 

[John Spencer]

There may be some other way to do it, but the only way I know of is to use
the undocumented SaveAsText function to write the text to a temporary text
file.

Arvin Meyer has a sample code at
http://www.datastrat.com/Code1.html
DocDatabaseText

 

[Guest]

Rather than beating yourself up trying to get it done yourself, check out the
Find/Replace utiity at this site. Free and Good.

http://www.rickworld.com/download.html