"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.