chrisveale
08-19-2007, 08:57 PM
Hi All.
We have an excel addin here *.xla that has some hugely useful functions in for us such as complex number processing.
This capability has been removed in VB.NET therefore I want to take a module I have in the xla and somehow compile that into a dll so that we can publish these functions into sonething we can hook into using vb.NET.
My question therfore is...
How do you take a module in VBA, and compile it into a library. Secondary I guess is how do you make the functions public so they can be called by another application?
Cheers
Chris
We have an excel addin here *.xla that has some hugely useful functions in for us such as complex number processing.
This capability has been removed in VB.NET therefore I want to take a module I have in the xla and somehow compile that into a dll so that we can publish these functions into sonething we can hook into using vb.NET.
My question therfore is...
How do you take a module in VBA, and compile it into a library. Secondary I guess is how do you make the functions public so they can be called by another application?
Cheers
Chris