Help converting Addin to library...

[chrisveale]

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

[Ken Puls]

So far as I'm aware, (although I could be corrected,) xll files are written in one of the flavours of C, not VB.

Here's a link from MS: How To Build an Add-in (XLL) for Excel Using Visual C++

[Bob Phillips]

How about a simple DLL that can be called from the XLA?

[rory]

To compile into a dll, you could use a copy of VB6 or Office Developer (depending on Office version) and it should be fairly painless. You could of course also rewrite it in .Net