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
 
Back
Top