I've got a list of approximately 12000 Workbooks. I want to be able to find
out which contain macros. Apart from opening each one manually is there a
way i can open the Workbook and programatically check to see if a macro
exists. I'm not concerned about number of procedures forms, Modules etc,
just to see if it contains even a recorded macro.

Thanks for any suggestions on this.
Regards,
John