Hi
strThisFileName = Activeworkbook.name

--
Regards
Frank Kabel
Frankfurt, Germany


Mike D wrote:
I have a line of code:

strThisFileName = "MY Excel FileName.xls"

How do I set my variable to the current excel filename?

strThisFileName = Workbooks.??

Thanks
Mike