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?
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