Encryption under VBA

[PjotrC]

Hi ,

I've tested under VB6 so far and here your class works well - but the actual goal is, to include the class in an Excel marco: here the archives are created, but they are not encrypted.
I am using Excel 2010 32bit under Windows 10 - but the marco should work for 32 and 64 bit Excel version and under all Windows OS from XP on (lower encryption strength for XP and Vista is ok, because these operating systems are also not really secure anymore).
Is it possible to make encryption work under VBA too?

Thanks for you work,
Peter

EDIT: It is working - my bad! In the Excel macro I forgot to add the new ZIP_CRYPTO = 1 arguement...

[wqweto]

64-bit VBA will be a problem. The ASM thunks are x86 only as my primary target VB6 is x86 only.

[PjotrC]

I see. I did not have a 64-bit Excel to test it - but your objection with the ASM thunks makes sense.
Unfortunately ASM thunking does not count to my skills...
I see, that you wrote a codegen project. How much work would it be, to make thunks for 64 bit?
What has to be changed for it?

The good thing with VB6 is, that it does not need any .net framework and runs under every Windows from XP on. But its also pretty outdated and almost dead. - VBA on the other side, is pretty vivid in all Microsoft Office apps. And 64-bit will be the future here. Wouldn't it make sense to have a 64-bit version of your awesome class for this case?