Hi All:

We have inherited the support of a couple of dozen Excel spreadsheets. These all have a bunch of VBA methods.

Is there some way we can open the spreadhseets and extract the method code so that we can build a big code database that can be searched

For example ..... Which methods in which spreadsheets reference a particular drive mapping???
Which methods in which spreadsheets use a specific DSN
etc.

How can we accumulate the VBA code to do those kinds of searches?

Thanks to all.....................Rich