PDA

View Full Version : Help converting Addin to library...



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

Ken Puls
08-19-2007, 09:45 PM
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++ (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q178474)

Bob Phillips
08-20-2007, 12:21 AM
How about a simple DLL that can be called from the XLA?

rory
08-20-2007, 12:51 AM
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