3

Basically, on Excel, I do want to create a signature from a secret key and message using HMAC SHA384.

I found some related articles but it was for HMAC SHA256

And some other research but no luck till now.

So, is it possible to do the same for HMAC SHA384 on Excel Mac OS?

S Meaden
  • 8,050
  • 3
  • 34
  • 65
Tom Tran
  • 186
  • 2
  • 3
  • 15

1 Answers1

1

I'm not saying this is an answer, it is just the comments have too few characters. This is an augmented comment.

I know very little about Mac Os development. I'm guessing that Mac Os has cryptography libraries just like windows, this might be it SHA384 - Apple Developer Documentation - (Swift) .

Then you'll need to code against that library, I'm guessing that will be in the Mac Os development language C++/Objective-C/Swift . Googling, objective c sha384 "mac os" - Google Search yields this as first match Objective-C Hash Algorithms_ SHA-1, HAVAL, MD2, MD5, SHA-256, SHA-384, SHA-512

Next challenge is to take the C++/Objective-C/Swift code and call it from Excel VBA. It seems on Mac Os the equivalent of a Windows Dll (Dynamic Link Library) is a dylib file. And here is a Youtube video that does that, How to build dylib for use in VBA within Excel for Mac OS - YouTube

I'm sorry I cannot give you a complete solution and also I apologise if some of the links do not match up (so the Apple link is for the Swift language and the YouTube video describes writing in C++). I have never programmed on a Mac but I hope this steers you in the right direction.

S Meaden
  • 8,050
  • 3
  • 34
  • 65
  • Thanks for your answer S Meaden, I really appreciate any help, even it's just an idea. I will try to do this way with a very single code first to see if it could work. If no one could provide other answers, I will vote the bounty for you. Thanks again! – Tom Tran Aug 02 '21 at 10:48