| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB6 Com Addin versus VBA Addin
I have a VBA Addin and a freind suggested that I move it to a VB6 com
Addin as it will improve the speed. I am happy that it will improve security but that is not an issue. Please could someone give some insight into this. Thanks in advance. Meldrum |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB6 Com Addin versus VBA Addin
In general you will not get any noticeable speed improvement with compiled
VB6 COM addins. There are some exceptions if you are doing extremely intensive VB arithmetic calculations (partial differential equations etc) or you are using 1000 or more calls to UDFs and have not bypassed the VBE refresh bug. Charles Williams Decision Models "meldrum_scotland" wrote in message ... I have a VBA Addin and a freind suggested that I move it to a VB6 com Addin as it will improve the speed. I am happy that it will improve security but that is not an issue. Please could someone give some insight into this. Thanks in advance. Meldrum |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setup project for Excel addin, won't register addin | Excel Programming | |||
| Removing an Addin from the Tools Addin list. | Excel Programming | |||
| Addin Help | Excel Discussion (Misc queries) | |||
| Unshimmed Automation Addin and Shimmed COM Addin in same App Domai | Excel Programming | |||
| Remove Excel AddIn from AddIn List !! Help | Excel Programming | |||
Hybrid Mode
