Detecting VBA code

[Chris Gorham]

Thanks for the suggestion on Chip Pearson's website.
I've managed to write the code to detect VBA contained
within sheets. However before it can run it requires that
I make a change to the references section contained in the
tools dropdown of the VBE. Chip discusses this.

Anybody know how to do this as part of the code so that
people who run my tool can have this change done
automatically..??

Chris

 

[Tom Ogilvy]

Actually, you don't

Instead of making your declaration like:

Dim VBComp As VBComponent

make it like
Dim VBComp As Object

Do this for any objects in the Visual Basic Extensions library.