Movian
08-24-2009, 05:13 AM
Hey,
just found this function designed for excel
http://www.vbaexpress.com/kb/getarticle.php?kb_id=285
im having a problem converting the line
sNum = left(sNum, Application.max(Len(sNum) - 3, 0))
more specifically
Application.max
What is the purpose of this ? and what would be an access equivalent.
just found this function designed for excel
http://www.vbaexpress.com/kb/getarticle.php?kb_id=285
im having a problem converting the line
sNum = left(sNum, Application.max(Len(sNum) - 3, 0))
more specifically
Application.max
What is the purpose of this ? and what would be an access equivalent.