Strip file extension from fiel name with multiple periods."file.9.69.txt"
 

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?

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?
.

Strip file extension from fiel name with multiple periods. "file.9.69.txt"
 

On Tue, 19 Jan 2010 15:23:01 -0800 (PST), 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?


Perhaps:

Left(activeworkbook.name, InStrRev(fn, ".") - 1)

--ron