Encryption in VBA

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I am writing some elementary encryption code in VBA. However, I a
discovering that VBA cannot handle the large size of my variables. Whe
using the code below I get overflow errors

Sub RSACalc()
Dim Var1 As Double

Var1 = 16346 ^ 39423 Mod 46927

End Sub

Var1 should equal 21,166. But obviously its choking on the sheer siz
due to the large exponent. Is there anyway to code this in VBA or am
forced to use something more powerful like Mathmatica?

Thank-you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top