Use ThisWorkbook.Name

To get the path:
ThisWorkbook.Path

So your code would be:
strThisFileName = Thisworkbook.Name

Toby Erkson
Oregon, USA

On Fri, 16 Apr 2004 10:51:40 -0700, "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