HI all,
I want to know which code runs faster VBA code or VSTO Solution
Thanx in advance,
Bye
Printable View
HI all,
I want to know which code runs faster VBA code or VSTO Solution
Thanx in advance,
Bye
I dont believe there is a measureable difference or any of a sizeable concern. The VBA code is allclient side but could involve a db or web request etc. The VSTO code would be complied into a dll which if local to the machine would be the same performance as the local client side vba code.
The benefit from the vsto code is that it is not embedded entirely in the xls file. The dll could be published on a server share and other client side workbooks could link to it and make updating the project (dll) easier as its only in a single place. Not to also mention that with VSTO you get better security and trust.
thanks