MD5哈希函数在excel中？ [英] MD5 Hash function in excel?

问题描述

我想将我的文档中的一些excel单元格从序列号转换为该序列号的MD5哈希值。有没有一个预编译的excel中的公式，或者是我唯一的选择VBA。如果VBA，我该怎么做？

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?

推荐答案

问题 Excel VBA的密码哈希函数现在已经被破坏了。以下是该问题的接受答案的更新版本：

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 :

您将在这里找到一个VB
和VBScript的实现：

http://web.archive.org/web/20080526064101/http://www.frez.co.uk/freecode.htm#md5

我相信这将是非常容易的移植到excel。

I believe it would be quite easy to port to excel.

然而有人已经这样做了。不幸的是，解决方案是
专家交换，不允许
直接链接。所以我们必须通过Google去
。 点击这里执行
a Google搜索，然后单击
的第一个结果。向下滚动很多以查看
接受的解决方案。

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.

资料来源： Excel VBA的密码哈希函数

这篇关于MD5哈希函数在excel中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！