Putting VBA functions into .dll

[Avatarp]

I have an Excel application that I want to make faster. I want to move all my functions code into .dll files. How should I go about this?

Thanks for any advice in advance.

[RobDog888]

Create an ActiveX dll project in VB and add the references to MS
Office 1.0 Runtime Type Library and the office application(s) that
you want to add the VBA code from. Then compile, but I think you
will still need to create a VBA project, but then you just need to
add the reference to the new dll file.

I think this is how it should be done.