Thanks Howard, excellent reasons.

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Howard Kaikow" wrote in message
...
"Charles Williams" wrote in message
...
I have only managed to find one case where Compiled VB6 code runs faster
than VBA when interacting with Excel (VB6 allows you to bypass the VBE
refresh UDF bug).

Have you found another situation where VB6 is significantly faster?

I use VB 6 for at least three reasons:

1. Most importantly, to protect the source code.
2. There's stuff in VB 6 not available in VBA.
3. Using VB 6 allows one to overcome some of VB 5 restrictions in Excel
97.