permanently add library reference
 

Hi there
I find it a bit irritating that I have to add a reference to the ADO library
every time I create a new workbook and VBA procedure. Is there a way to do
this permanently?
Best regards
Loane

permanently add library reference
 

Don't know how to change this for a new workbook in general, but an easy
enough way to do it is to create a blank workbook, add the ADO reference, and
save it as a template. Whenever you need to do an ADO project just open the
template and you have a blank workbook with the ADO reference all set to go.
--
- K Dales


"Loane Sharp" wrote:

Hi there
I find it a bit irritating that I have to add a reference to the ADO library
every time I create a new workbook and VBA procedure. Is there a way to do
this permanently?
Best regards
Loane