Strip file extension from fiel name with multiple periods. "file.9
Try using INSTRREV , it gets the first "." from the end.
--
HTH,
Barb Reinhardt
"Fan924" wrote:
I am using this to strip the file extension off of a file name
Range("G6").Value = Left(ActiveWorkbook.Name, InStr
(ActiveWorkbook.Name, ".") - 1)
It messes up with multiple "."
How do I strip off the file extension and far right "." only?
.
|