Link to home
Start Free TrialLog in
Avatar of lblinc
lblincFlag for United States of America

asked on

VB Script - VBA - ActiveX - Encryption/Cryptography question

Background :      The company is currently using a "discontinued ActiveX control" (CAPICOM)  and considering WIN7 deprecation issues we've been asked to come up with a plan to migrate off of the  "discontinued ActiveX control" cryptographic library.  

Note :  The business unit currently use SHA1 hashing and AES256 encryption.  

The solution we're seeking to migrate to must use a standard library to implement cryptography.


Microsoft discusses Alternatives to Using Capicom here but we do not see anything that applies to VBA:  http://msdn.microsoft.com/en-us/library/cc778518(VS.85).aspx

 
Question  :    Is there a standard way in VBA code in MS Access or Excel to implement hashing and encryption by setting a reference (early or late binding) or a call to Windows API or some other way?

 i.e..

Call a Windows API function by Declaration:  eg: Private Declare Function GetSystemMenu Lib "user32" (ByVal hWnd As Long, ByVal wRevert As Long) As Long

Early-bind a library by setting a References in Tools.References

Late-bind a library:  Set objVar = CreateObject(“ObjectName.Here”)
Avatar of lblinc
lblinc
Flag of United States of America image

ASKER

All :     There is no wrong answer here...    Looking for any suggestions, or recommendations.  

I've been doing some research on this issue and have found very little, other than some interesting posts re:  others facing close to a similar task(s)  ...      seeking to migrate off the CAPICOM cryptographic library.
ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial