Jim,

Sounds like you're going to have to combine a few methods. While I don't
have a specific idea, I suggest you start with Chip Pearson's Website on
Programming to the Visual Basic Editor (VBE) at this url:

http://www.cpearson.com/excel/vbe.htm

You will have to open each workbook on your network and check its VBE
objects for "vbext_ct_ClassModule" and "vbext_ct_StdModule". Don't forget to
add a reference to "Microsoft Visual Basic For Applications Extensibility" in
Tools- References, and you will need to go to the Tools menu, choose Macros,
then Security, click the "Trusted Sources" tab, and put a check next to the
"Trust access to Visual Basic Project", as Mr. Pearson describes in the above
site.

Good luck.
Pflugs

"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.