Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How much slower is Excel VBA compared to Visual Basic .net?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How much slower is Excel VBA compared to Visual Basic .net?
VB.net with Excel is probably slower than VBA with Excel because of the
extra interop layers it has to go through. The syntax is sufficiently different that converting the code is a significant rewrite. I would recommend looking at the usual slow VBA reasons before migrating: Application.screenupdating=false application.calculation=xlmanual Read data from a range into a variant containing an array as a block of cells rather than cell-by-cell Process the data using arrays Write the data back to a range as a block of cells from the array Application.screenupdating=true application.calculation=xlautomatic Charles _________________________________________ UK Cambridge XL Users Conference 29-30 Nov http://www.exceluserconference.com/UKEUC.html "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Programmatic access to visual basic project via Visual FoxPro | Excel Programming | |||
Make visual basic truely visual! | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |