Hi all, i am trying to get the file name and then trim off the ".xls"
from the end.
myFileName = Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 4)

This then give me an error as per the subject line. Please could
somebody give me some help.

thanks.


Les Stout

*** Sent via Developersdex http://www.developersdex.com ***