VB6 Com Addin versus VBA Addin

  • Thread starter Thread starter meldrum_scotland
  • Start date Start date
M

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
 
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
 
Back
Top