Commercialising VBA Applications

[Varne]

Hello

Good Morning.

Can someone please tell me why Excel VBA applications are not considered
suitable for commercial applications?

Thank You
M Varnendra

 

[Chip Pearson]

I wouldn't necessarily consider VBA apps not "suitable for commercial
applications", but VBA does have some drawbacks. First, it is interpreted
code, so it runs slower than compiled code (e.g. VB6, C/C++) or JIT compiled
code (NET). Next, VBA isn't secure. It is very simple to break the password
protection of a VBA Project, so intellectual property such as proprietary
algorithms can be seen by any user. Most of what I write is in either VB6 or
VBNET, but I have written more than a few commercial application in VBA.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Varne]

Hello

Thanks.

M Varnendra

I wouldn't necessarily consider VBA apps not "suitable for commercial
applications", but VBA does have some drawbacks. First, it is interpreted
code, so it runs slower than compiled code (e.g. VB6, C/C++) or JIT compiled
code (NET). Next, VBA isn't secure. It is very simple to break the password
protection of a VBA Project, so intellectual property such as proprietary
algorithms can be seen by any user. Most of what I write is in either VB6 or
VBNET, but I have written more than a few commercial application in VBA.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)