Finding Excel Macros

[Bill]

I have been tasked with finding all the Excel worksheets
on a given
server that contain macros.... Does anyone know an easy
way of doing
this?

 

[Tom Ogilvy]

You would need to loop through all the worksheets, open them, and examine
them for macros.

Look at help on the filesearch object to see code to loop through the files

See Chip Pearson's site for code to find code:

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

I don't think it has that specific application, but it has code close
enought that you should be able to adapt it.