View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How much slower is Excel VBA compared to Visual Basic .net?

VB.Net will be intrinsically faster because it is compiled. But conversely,
it adds an another layer to be dealt with by the code. And maybe most
significantly, it is a different development paradigm, so the learning curve
is not insignificant.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sing" wrote in message
...
Dear Excel Gurus,

After adding several features, my worksheet running Excel VBA has become
very slow. I am thinking of migrating the VBA application to Visual Basic
.Net

I have 2 questions;
1. For an estimate, how much faster is Visual Basic .net as compared to
Excel VBA?
2. How different is the code syntax of Visual Basic .net as compared to
Excel VBA?

Thank you.