View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Howard Kaikow Howard Kaikow is offline
external usenet poster
 
Posts: 269
Default Excel 2007/Excel 2003 compatibility

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