keeping part of a string

[stoney1977]

I need to keep part of a string to use for other things.

myworkbook = thisworkbook.name

I need to have another string the holds the workbook name with out the ".XLS"

How can I do this