I'm a VBA (excel) programmer who has recently started using visual studio 2005 and purchased the beginning visual basic 2005 book.
I have managed to create a class library dll from the book containing a class with simple math functions (which I can call from VB2005). However, I do not know how to access this dll from VBA (which is desirable for legacy reasons).
Is it possible to create dlls in VB2005 that can be accessed from VBA?
There appears to be a way to do this, which is outlined at:
I have tried compiling a dll in VB2005 based on this code, but it doesnt seem to work.