View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Hanby Mike Hanby is offline
external usenet poster
 
Posts: 2
Default 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