Is it possible to return the MS-DOS name of a file to an excel worksheet?
I don't need the entire path, but just the name of the file (excluding ".xls" if possible).
For Example, if the path is
- C:\My Documents\TEST.xls
I only need TEST returned in a cell on the worksheet.
Any ideas?
I don't need the entire path, but just the name of the file (excluding ".xls" if possible).
For Example, if the path is
- C:\My Documents\TEST.xls
I only need TEST returned in a cell on the worksheet.
Any ideas?