Thread: Strip file extension from fiel name with multiple periods."file.9.69.txt"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default 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?
Reply With QuoteReply With Quote