Use something like this

=InstrRev(myWB.name,".")

HTH,
Barb Reinhardt

"Michelle" wrote:

I'd like to be able to separate the extensions from filenames, do I have to
find the last '.' ? If so what's the best way?

In the back of my mind there is a statement that reurns the filename with
out the extension - or did I dream that?

Thanks

M