I was on a project to do something similar, and besides an automated
chaeck, there was a need to have each Excel file with potential
code/upgrade issues checked. I believe there is a HasMacro bit you can
check on each file.

Also, if that doesn't exist, you can count the lines of the modules,
trim the empty space, then have a some criteria where the string needs
to be greater than some small value to qualify as having code.


James Igoe

|| http://code.comparative-advantage.com


Jim Hicks wrote:
I was given a project to scan all of the Excel files on our network and
generate a report listing the
files and wether they use Macros. I was thinking of using VB6 to scann all
dirs/subdirs...easy part.
Question: -- How do I quickly scan an excel file and determine if it
has/uses Macros using VB6.
I appreciate you taking the time to read this and any help anybody can
provide. Thanks.