| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing the file extension while listing files via foundfiles
I am trying to list a group of files using foundfiles. I am interested
only in the file name, not the path ofr the extension. I can remove the path by using the split function and a "\" as a delimiter. I then take the upper bound of this to get "filename.ext". How can I get the file name alone? I cannot use "." as a delimiter because some of my files have "." in their file name. (eg. house.pic.summer.jpeg) Anyone have any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can you open files with extension xlsx? | Excel Discussion (Misc queries) | |||
| How do I convert Quattro Pro files with .wb3 extension to Excel? | Excel Discussion (Misc queries) | |||
| files with no extension | Excel Discussion (Misc queries) | |||
| Using .FoundFiles to list files by path and file name | Excel Programming | |||
| How to covert old Lotus 123 files with .123 extension to Excel? | Excel Discussion (Misc queries) | |||
![Jon[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
