Replace all Trim(), Left(), Right(), Mid() etc with Trim$(), Left$(), Right$(), Mid$() . These are string functions which will increase the speed
Also
If you are comparing if a string is empty
use
Len(Trim("STring")) = 0
rather than
Trim("STring") = ""
Even better would be
LenB(Trim$("STring")) = 0
as LenB() would be faster than Len().
More functions in coming articles...
Cheers
Shasur
Free Search Engine Submission
No comments:
Post a Comment