One way is to add the program to the references Tools | References i
VBE. Then you can check by typeing Dim Obj as, and you will get a lis
of what you can declare it as. When you find the program in the list
that's the value you use.

For example, a ADO connection (referencing Microsoft ActiveX Dat
Object) would look like this:

Dim objConn As ADODB.Connection

so you would use

Set objConn = CreateObject("ADODB.Connection")

HTH



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26548