Store the Spreadsheets filename in a variable?
 

Hey all,

How can I get the filename of the spreadsheet and store that string in a
variable using vba? (just the filename, not the path)

Essentially, I'd like to be able to print out the filename of the
spreadsheet without having to hardcode the name.

Sort of like in bash, how you can refer to $0.

Thanks,

Mike

[Solved] Store the Spreadsheets filename in a variable?
 

Dim fileName As String
fileName = ActiveWorkbook.Name

Mike Hanby said the following on 03/17/2005 16:15:
Hey all,

How can I get the filename of the spreadsheet and store that string in a
variable using vba? (just the filename, not the path)

Essentially, I'd like to be able to print out the filename of the
spreadsheet without having to hardcode the name.

Sort of like in bash, how you can refer to $0.

Thanks,

Mike

Store the Spreadsheets filename in a variable?
 

Worksheets("Sheet1").Parent.Name



On Thu, 17 Mar 2005 16:15:51 -0600, Mike Hanby
wrote:

Hey all,

How can I get the filename of the spreadsheet and store that string in a
variable using vba? (just the filename, not the path)

Essentially, I'd like to be able to print out the filename of the
spreadsheet without having to hardcode the name.

Sort of like in bash, how you can refer to $0.

Thanks,

Mike