VB6 Com Addin versus VBA Addin

[meldrum_scotland]

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

 

[Charles Williams]

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