Steve..

Read carefully what I posted a week ago..:(
I've snipped the rest.. but left what's now bugging you.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Steve wrote :

I just found time to try this out... I get an error message while
running tstpump: Compile Error: User-defined type not defined.

The debugger highlights the following in yellow:
Dim cnn As ADODB.Connection


Any suggestions? Thanks your coolness.

"keepITcool" wrote:

Alternative:


Option Explicit
'Code needs a reference to Microsoft ActiveX Data Objects 2.5 or
higher)