Gentlemen, I am new to Excel VBA a
Gentlemen, I am new to Excel VBA a
(OP)
Gentlemen,
I am new to Excel VBA and have got to the stage when I write my own function procedures and make available to all my spreadsheets as addins. I have about 40 engineering functions/addins and the number is growing.
I am now wandering if there is any advantage in compiling the VBA functions or addins in terms of increasing speed.
If there is, is there a good book that would tell me how to proceed.
Regards,
athomas236
I am new to Excel VBA and have got to the stage when I write my own function procedures and make available to all my spreadsheets as addins. I have about 40 engineering functions/addins and the number is growing.
I am now wandering if there is any advantage in compiling the VBA functions or addins in terms of increasing speed.
If there is, is there a good book that would tell me how to proceed.
Regards,
athomas236





RE: Gentlemen, I am new to Excel VBA a
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrsigningvbaproject.asp
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Gentlemen, I am new to Excel VBA a
Thanks for advice.
athomas236
RE: Gentlemen, I am new to Excel VBA a
My experience is that VBA codes can be sped up a lot. I would also suggest you use the timer function to see where your time consuming subroutines are.
RE: Gentlemen, I am new to Excel VBA a
athomas236
RE: Gentlemen, I am new to Excel VBA a
dongxiao PE
http://www.cadtool.net
RE: Gentlemen, I am new to Excel VBA a