VB6 Addin help please

[Ian Bayly]

I'm struggling with the following.
I have a project which of necessity runs both VBA(Word 2000+) and a VB6
Admin routine running as a VB6 exe.
There are many common routines, notably some encryption/decryption and ADO
routines.
I don't want to maintain 2 code sets and I believe I should be able to
package the common routines in a dll and call functions from both VBA and
VB6.

That's as far as I get, I have a moderate knowledge of VB6 but despite all
my manuals purchased and searches I have a mental block with this thing
called a "class"
All the examples I have seen concentrate on adding command bar buttons, I
have worked through them, but I don't want to add a command bar button, I
want to call a routine direct from VBA or VB6 code.

Can any one give me a pointer on using an addin which does not merely create
and manipulate command bars - or is that all an addin can do?

TIA

Ian B

[Ian B]

Another few hours research and I came up with this (link for others who may
need help)
http://www.insteptech.com/techLibrary/vbClassic/vb6_active.htm

Have got this working from both VB6 exe and VBA - it's a start I can build
on.

Ian B

Post by Ian Bayly
I'm struggling with the following.
I have a project which of necessity runs both VBA(Word 2000+) and a VB6
Admin routine running as a VB6 exe.
There are many common routines, notably some encryption/decryption and ADO
routines.
I don't want to maintain 2 code sets and I believe I should be able to
package the common routines in a dll and call functions from both VBA and
VB6.
That's as far as I get, I have a moderate knowledge of VB6 but despite all
my manuals purchased and searches I have a mental block with this thing
called a "class"
All the examples I have seen concentrate on adding command bar buttons, I
have worked through them, but I don't want to add a command bar button, I
want to call a routine direct from VBA or VB6 code.
Can any one give me a pointer on using an addin which does not merely create
and manipulate command bars - or is that all an addin can do?
TIA
Ian B