lblinc
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.H ere”)
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.H
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The link appears to be broken. This works:
https://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=74645&lngWId=1
https://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=74645&lngWId=1
ASKER
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.