06-10-2011, 06:12 PM
Hi,
We can increment all ur test SSN as given below.
We can increment all ur test SSN as given below.
Code:
SSN="123-12-1239" ' old SSN
SSN = Cstr(CLng(Replace(SSN,"-",""))+1)
SSN = Left(SSN,3) & "-" & Mid(SSN,4,2) & "-" & Right(SSN,4)
msgbox SSN ' prints new SSN