Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filename without dir & sheet name
Tried =cell("filename",ref) but could not find how to remove the entire
directory and the worksheet name. I only require the .xls filename without the sheet name. ie. "c:\..\Template.xls[worksheet]" becomes "Template" only. Excel help no help and searched here but nothing appeared similar. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically printing to PDF with the filename as the sheet name | Excel Discussion (Misc queries) | |||
Need help, Seq numbers, Save filename & A button on sheet. | Excel Discussion (Misc queries) | |||
hyperlink to sheet in formula, can't save under new filename | Excel Worksheet Functions | |||
Is there an automatic display/print the filename on sheet in Exce. | Excel Discussion (Misc queries) | |||
vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) |