Code not running on new computer

[John Wol]

I have a small .xlsm file which contains two simple macros and a VB module designed to return a 10-character hash from a character string using "=BASE64SHA1(A1)". I'm not skilled in VB so I simply found the code from a web site. The only mod I made was to set the length of the hash to 10 characters.

I've been using this file regularly for about a year on each of three computers without problems all using Office 365.

I have recently bought a new computer, installed Office 365 and tried to use the file. "=BASE64SHA1(A1)" only returns "#VALUE". The other two macros in the file work correctly. The same file continues to work correctly on the other computers.

I have compared the Excel options on the new computer with those on one of my other machines they all seem identical but I might have missed something.

I would be grateful for any help you might be able to offer.

 

[John Wol]

Thank you for your reply. I am away from home (and the offending computer) for a couple of days. I'll look at this on my return.

 

[John Wol]

Problem solved!!!

While trying to do something else, I received an error message saying that I needed to install .NET. I've no idea what that is but I installed it anyway and now the code runs.

Thank you for your help with this.

 

[mole999]

.Net is used in a lot of things from microsoft