Add File Name to a Cell without Extension?

[slam]

Hi all,

I've seen a few ways to do this, but they don't account for file extensions being different lengths - typically 3 (.xls) or 4 (.xlms)

Is there anyway this can be done? My file names will never have a period in them if that helps.

Thanks

 

[PBWood]

Thanks very much, I'll give this a go!

It didn't work at first, but that's because someone (in their infinite wisdom) decided to include a "." in the user names, which then formed part of the full file address. I solved it by adding in the section of code you use for the start of the MID so that it finds the first "." after the beginning of the file name.

Thanks again for your help!