Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDF's via Automation Addin in Excel 2010? | Excel Worksheet Functions | |||
Excel C# AddIn | Excel Programming | |||
Excel Addin help!!! | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming | |||
Excel COM Addin | Excel Programming |