VBA – Hashing in Excel with HMACSHA1

Hashing strings in general is useful. It is one of the good things, that we get from granted by the various .Net libraries and we should not try to do on our own, as the HMACSHA1 is quite a powerful algorithm, providing good hashes.

Hashing the sky!

If, by any chance you are wondering how to get a HMACSHA1, encoded in BASE64, then you are on the right place. The two functions below will show you how:

That’s all! Quite ok for Excel.

Tagged with: , , , ,