Hi guys,

Can anyone please let me know whether any code exists which separates a
workbook name from its extension (e.g. a spreadsheet named "test.xls" would
be separated into "test" and ".xls")?

Thanks in advance,
Will