Excel and cross-workbook code

[alkatran]

In the VBA Editor with the reference to your dll, use the Object Browser to see
if you can see your function in the module. If its declared as Public then it
should be visible in the OB.

They don't show up, and they are all declared public.

[RobDog888]

I'm not 100% fluent at dlls, but it should be visible. What if you placed it in the class?

[alkatran]

I'm not 100% fluent at dlls, but it should be visible. What if you placed it in the class?

I tried placing it in the class, but I would have to rewrite all the functions calls to include the "class.", and the classes called by the dll would be different instances than the ones I called (inside one class another is called, so it must be declared with, etc.) I just decided that this type fo thing didn't belong inside a DLL.

[RobDog888]

If a dll is no longer considered the way to go then what about the Add-In?

[alkatran]

If a dll is no longer considered the way to go then what about the Add-In?

I just realized I can include a form in the dll, and use control arrays in excel!

I'm going to stay the path of 'copy-paste' for now.