René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

variant to long conversion [VBA]

option explicit

public sub var_to_lng()

  dim var as variant
  dim lng as long

  var = "49090890890485894817398748173"
' lng = var ' Run-time error '6': Overflow

end sub
See also other VBA stuff