Excel VBA to a DLL
I've written a bunch of financial analysis stuff in VBA user defined functions as part of a model and I'm talking to a potential user (a major bank) who doesn't want to use it in Excel but instead wants a DLL they can address from their systems. I'm kind of thinking I could move my VBA stuff over to Visual Basic (which I've never used, but hey, it's basic after all!) and then use this to migrate the functionality to a DLL.
I really have no idea if this is a viable strategy and wonder if anyone could advise or suggest a viable alternative. I'm pretty comfortable with VBA but haven't done anything like C or C++ before.. I did suggest an Add-In but that didn't seem to cut it for them.
Thanks for any advice