";-)" wrote in message
...
Thanks for the reply, I guess I left off some details of my situation.

My clients creates the Excel sheets without any database parts. Their
current versions are Win 2K, with Office 2K.

I have Win XP pro and Office XP. I only create a callable function inside
their Excel sheets that allows me to pass an ADO recordset between their
Excel sheets and my VB 6.0 application. (I give them an almost blank
recordset, and their Excel code just fills in the blanks).

Public Function getRs(ByRef rs As Object) As Object

is the function definition I use inside of the Excel VBA. I don't have to
do anything different than this. BUT I would prefer to not have to use
the
"Object" qualifier since this limits their/my use of help functions inside
Excel. I do use some properties like .definedSize which would not be
obvious to them when I turn maintenance over to them.

I got it to work by referencing the rs as and ADO object, but their only
engineer smart enough to know how to install the latest MDAC to make it
work
on his computer left the company.


SO would

Public Function getRs(ByRef rs As Recordset) As Recordset

work on their system with out them having to install anything with the ADO
recordset I pass??


They will need MDAC since that installation contains the ADO object
definitions
however so many core programs use MDAC these days (including Internet
explorer IRC) that its probable its already installed.

If it isnt installing MDAC is a trivial task. The only complication is that
they may have to set the references from their Excel Workbooks
if it wasnt already installed.

Keith