Re: VBA References DIalog

From:

"Alexander Nickolov" <agnickolov@mvps.org>

Newsgroups:

microsoft.public.vc.atl

Date:

Fri, 1 Sep 2006 11:22:09 -0700

Message-ID:

<eNElKOfzGHA.4976@TK2MSFTNGP02.phx.gbl>

I presume the list contains all type libraries registered on the
system (like in VB6). Beware you need to create a simple
ATL object, not a control.

--
=====================================
Alexander Nickolov
Microsoft MVP [VC], MCSD
email: agnickolov@mvps.org
MVP VC FAQ: http://www.mvps.org/vcfaq
=====================================

"metcarob" <robert.metcalfe@greenwich.gov.uk> wrote in message
news:1157098730.867204.119990@e3g2000cwe.googlegroups.com...

Hi,
I am writing an application in C++ and I want to provide an interface
to VBA.
I would like to provide the interface in the same manor as Microsoft
DAO.

i.e. VBA programmers would click on Tools -> References, they would see

my libary listes on this list.
They would then be able to see the interfaces in the intellisense lists

in VBA.

I would like VBA programmers to access my functions by writing
something like:

dim rs as MYLIB.recordset
dim m as MYLIB.mainobject

set m = MYLIB.GetMainObject
set rs = m.getrecordset(123)
while not rs.eof
msgbox(rs!Field)
wend
rs.close
rs=nothing
m=nothing

I have been reading up on ActiveX controls and COM objects, even used
C++ to create some COM objects. The problem is I can't seem to find out

how to make my libary appear in VBA's list.
I presume there is a set of COM interfaces I need to implement, or
there is a name for the particular type of COM object I need to create.

If anyone could point me in the right direction, or give me enough to
do a search to find more info I would be grateful.
Thanks
Robert