Hi,

I am trying to store the contents of the ADODB .CommandText property at run time every time it's value changes.
This will allow me to collect all the used SQL and make a proper impact analysis of our companies proposed system changes.
I have attempted to do this with an Add-In but I don't know enough about writing Add-Ins to pull it off.
It needs to be reusable across hundreds of programs so any ideas very welcome.

Kindest regards,

Matt.