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

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

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