【转帖】macro code help
 

macro code help
if i use the code below to strip off the last 6 characters of a file name, what code would i use to capture and store the first two characters of the file name?
filename = strings.left(filename, len(filename) - 6) & "pdf"
my goal is to capture and store the first to characters and then us those characters to set the dir to save a file into.
thanks.
todd
check out our whitepaper library.
filename = strings.left(filename, (len(filename) - (len(filename) - 2)))
this will return the first two characters of the string "filename"
there is probably an easier way to do it, but it works.
strings.left(filename, n)
this just takes the first n characters from the left side of filename. so if you want to retrieve the first two letters of filename, use
strings.left(filename, 2)
strings.left(filename, (len(filename) - (len(filename) - 2))) will work, too. however, if you look closely it's really saying strings.left(filename, x - (x - 2)). x - (x - 2) = 2, so you're back to strings.left(filename, 2).
wow, do i feel dumb. math has always been my strong point, too.
thanks for the input guys! i can always count on this forum!
have a great weekend.
todd