| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing the file extention
If the filename also has its path with it...
FileNameOnly = Mid(Left(PathAndFilename, InStrRev(PathAndFilename, _ ".") - 1), InStrRev(PathAndFilename, "\") + 1) If the filename is by itself (that is, without its path)... FileNameOnly = Left(FilenameAndExtension, _ InStrRev(PathAndFilename, ".") - 1) -- Rick (MVP - Excel) "Fan924" wrote in message ... Is there an easy way of removing the file extention from the file name? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel XLW file extention | Excel Discussion (Misc queries) | |||
| How can I turn on or off for backup file with XLK extention? | Excel Discussion (Misc queries) | |||
| file extention .xsls | Setting up and Configuration of Excel | |||
| changing file extention names | Excel Discussion (Misc queries) | |||
| Problem w/ open no extention file | Excel Programming | |||
Hybrid Mode
