Can we protect VBA code?

Is there a way to encode or similar our VBA code, or make it not accessible/viewable to users, so that others can't copy/modify our code?

Regards,

Graham

Parents
  • Jon Summers:
    Microsoft wants us to use .NET, and does not want us to use VB6.

    Microsoft wants too many things in my view..., and this may be a good reason for exploring alternative software (Borland software for example)

    DanPaul:
    but we should not forget about obfuscation :)

    Yes, I agree with Dušan, but in the context of my comment above.

    Regards,

    Marcos

  • Marcos Perelmuter:

    Microsoft wants too many things in my view..., and this may be a good reason for exploring alternative software (Borland software for example)

    What product from Borland can be used for copy-paste reproduction of existing VBA code into ActiveX DLL? If you mean C++, this is still usable without .Net in new Visual Studios, where we can do it, but it is not copy-paste and not as straightforward easy operation as in case of .NET or old VB6. 

     

  • Dušan,

    DanPaul:
    What product from Borland can be used for copy-paste reproduction of existing VBA code into ActiveX DLL?

    True that Borland may not provide the "straightforward magics" of running VBA intact, I wish it did. But your secrets can be writen and compiled into DLL using for example "Delphi"and then be called from VBA.

    Further, this code can be easily protected using third party protections, even using encryption technology.

    Now, it is up to the programmer, YOU, if your code is very valuable, it will be worth to use languages other than VBA, spend the time to learn and implement them, and compile your programs into safety. If you pretend to use an unsafe language as a base for your valuable code, then you should be aware of the risk involved.

    Anyway, if you insist with the "copy and paste" operation you may be surprised of the variety of DLL compilers available. But of course, you need to experiment and make research on them.

    For my part, I cannot accept Microsoft's monopoly and I may expand my research into alternative compilation tools also.

    Best regards, Marcos

  • Marcos Perelmuter:

    For my part, I cannot accept Microsoft's monopoly and I may expand my research into alternative compilation tools also.

    I understand you and think that you are not alone, but while Windows are the most supported OS in the world, you have not many options... 

Reply Children
No Data