View Single Post
 
Old 10-07-2014, 01:49 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In that case, I have to assume whatever else you have is tripping up over the Evaluate finction. Try replacing each instance of:
StrConv = Evaluate(Replace(Replace(StrConv, "-", "+"), "'", "*12+0"))
with:
Code:
              If InStr(StrConv, "-") > 0 Then
                If InStr(StrConv, "/") > 0 Then
                  StrConv = Split(StrConv, "-")(0) + Split(Split(StrConv, "-")(1), "/")(0) / Split(Split(StrConv, "-")(1), "/")(1)
                Else
                  StrConv = Split(StrConv, "-")(0) + CSng(Split(StrConv, "-")(1))
                End If
              End If
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote