I have a client with a number of workbooks, which were generated from a
template. The template has been through a number of revisions. For
simplicity's sake, v1 did not have a given macro XXXX in, v2 did, and v3 (and
subsequent versions) did not.

Is there a way to identify whether a given workbook contains the macro XXXX
(but without running the macro) programmatically, so that those workbooks can
be backed up, and manually modified?

The presence of the macro actually tells us that some other VBA code in the
document is incorrect and will need updating, nothing more sinister, and
while I am familiar with 'standard' VBA stuff and automation in general (I
also design and code in C++, including COM servers and clients), I know
little about the internal structure of workbooks (since I've never needed to,
that's what automation is for...), so I'd appreciate any pointers. I
estimate that in total there are around 4500 documents to check, and
unfortunately, most have been updated on a regular basis, so datestamps don't
help (although some can be eliminated by creation time).

Thanks in advance
--
Steve S