Thread: Excel Filename prgramatically
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mike D[_3_] Mike D[_3_] is offline
external usenet poster
  
Posts: 5
Default Excel Filename prgramatically
NeverMind

ThisWorkbook.Name
-----Original Message-----
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
.

Reply With QuoteReply With Quote