Hello,
I would like to convert a number of excel cells in my document from a serial number to the MD5 hash of that serial number. Is there a precompiled formula in excel that does that, or is my only option to do VBA. If VBA, how would I do it?
+4
A:
Some links in the question Password hash function for Excel VBA are now broken. Here is an updated version of the accepted answer on that question :
You'll find an implementation for VB and VBScript here:
http://web.archive.org/web/20080526064101/http://www.frez.co.uk/freecode.htm#md5I believe it would be quite easy to port to excel.
However someone has already done that. Unfortunately the solution is at experts-exchange which doesn't allow straight links. So we have to go through Google. Click here to perform a Google search and then click the first result. Scroll down a lot to see the accepted solution.
Source : http://stackoverflow.com/questions/125785/password-hash-function-for-excel-vba/125844#125844
HoLyVieR
2010-08-17 00:18:00
:D Wow, since when can you view answers on Experts Exchange for free? I remember you had to register before, so I haven't been there for years now.
casablanca
2010-08-17 00:24:37
@casablanca If you get to a expert exchange question from a Google link, you will be able to access the answers. If they didn't let you see it, they would have been banned from Google long time ago. It's against Google policy to display different content to Google Bot and normal user.
HoLyVieR
2010-08-17 00:34:21