Does anyone know why an Excel Macro would be faster than VB.net code?
I wrote a macro to process about 1000 rows of an Excel spreadsheet. After losing the macro (found it later) I decided to rewrite the code in VB.net. When I found the macro I used the same code, modifying some features that don't work in VB.net, and found that it ran much much slower than the macro. The macro runs the entire 1000 rows in about 20-30 seconds. The VB.net code could only get through about 40 rows in the same amount of time. Is VB.net that much slower normally of is it something within Excel or is it my code? Just curious if anyone knows.