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.