I need to be able to calculate checksums (CRC32 algorighm) in Excel VBA
using Excel 2003. I have encrypted passwords and security groups from
another application, and they will have to login to an Excel form. I
cannot export the encrypted info into Excel since I have no way to
translate it back to its original value.

Instead, I thought if I first decrypted the data and replaced it with
checksums, the password wouldn't be brought into Excel, which would add
another measure of security for the application, since even if an
enterprising user went hunting and found both userlist files, the
password and security group would be different in each file, and there
would be no obvious key that would hint at how they are related.

I cannot, however, find any code that shows how to calculate checksums.
I'd be very grateful if someone could point me in the right direction.
Thanks!



Henry
DPM Mellon