Tuesday, 11 July 2017

So my Excel-VBA project password can easily be cracked... What are other options?

Practically, VBA obfuscators do not protect VBA code because they leave the structure of the algorithm unchanged, which can be traced back to the original algorithms which can then be recovered.


Converting your VBA code to VB6 means your application will be limited to 32bit Excel (VB6 doesn’t have a 64-bit version) and it can be decompiled by VB decompilers such as https://www.vb-decompiler.org/


Converting your VBA code to VB.NET isn't a perfect solution either, as .NET has a ‘reflection’ mechanism which can convert the compiled code of .NET assembly into the original source code.


You can convert your VBA code to C/C++, which would be a very effective form of protection, but since C/C++ and VBA are very different programming languages, the conversion of VBA code to C/C++ is difficult, error prone, and generally not worth the huge amount of time and effort that it takes.


There is a tool called VbaCompiler for Excel (http://vbacompiler.com) which converts the VBA code to C language code and then compiles it into a DLL. The level of protection this tool claims to provide is similar to that of converting your VBA code to C/C++ but without the massive amount of manual work that is required for such a process.

No comments:

Post a Comment

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...