Automation COM Addin with Excel
 

I am moving my library of VBA functions to a COM automation addin.
Here are some questions -

1. How can I add the addin functions code to .bas (module) files
instead of only to the .dsr file as described in the MSKB article
285337 "Create a Visual Basic Automation Add-in for Excel Worksheet
Functions"

2. I would like a rgistration form to pop up when the a user first
uses the COM add-in. Thus far II'm doing this as follows -

Private Sub AddinInstance_OnStartupComplete(custom() As Variant)
Call ShowForm
Exit Sub
End Sub

The form only pops up when a user clicks the insert function wizard.
If the insert function icon is not clicked and the user instead enters
=P then Excel crashes. What is the right way to do this?

3. Is it possible to add argument help to the COM automation addin
for Excel? If so how?


Any help would be greatly appreciated.

Regards,
Puneet