vba - Com DLL In VB6?

Question

I have a class in an Excel file and my boss wants me to create that class into a COM DLL. I don't want to have him walk me through the entire process because he's quite busy.

Can any of you point me in the right direction and help me out with this?

Answer 1

1. Start Visual Basic.
2. Create a new 'ActiveX DLL' project.
3. Rename the 'Class1' class to the name of your class.
4. Rename the project to something sensible.
5. Paste the code from Excel into the class code window.
6. Save the project and its files.
7. Build the .dll (File -> Make...).

Depending on the code in your class (and its dependencies), you may need to add one or more references (Project -> References...) before it will build without errors.