Prev: Routine does not run when workbook is opened
Next: copying cell comment from one sheet to another
From: Barb Reinhardt on 19 Jan 2010 19:27
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?
> .
>
 | 
Pages: 1
Prev: Routine does not run when workbook is opened
Next: copying cell comment from one sheet to another