| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Workbook name
I have a workbook which has a list of path and filenames for workbooks.
I want to extract from each of these the workbook name only. e.g From this path I want to extract only the name "Lucky Draw.xls" C:\Documents and Settings\Bbrian\My Documents\My Documents\Brian docs\Clay\Clay WorkBooks\Workbooks\Lucky Draw.xls Each of the path names are vaiable lengths and a variable number of sub direcotries |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Extracting Data from one workbook to another | New Users to Excel | |||
| excel exits unexpectedly or hangs the second time I open workbook | Excel Discussion (Misc queries) | |||
| Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Threaded Mode
