set the value of a string to the name of the excel file you are applying the code to

Question

As the title says, I want to get the name of the file saved as a string. I have

wstitle = Application.Caller.Worksheet.name

and it forces the n to lower case and doesn't work.

possible duplicate of [How to get the path of current worksheet in VBA?](http://stackoverflow.com/questions/2813925/how-to-get-the-path-of-current-worksheet-in-vba) — Alex K., Oct 09 '14 at 16:23
It would seem that the application call is referencing a different form of `.Name` than one of these standard calls. `wstitle = ThisWorkbook.Name` or `wstitle = ActiveWorkbook.Name`. — , Oct 09 '14 at 16:34

Gary's Student · Answer 1 · 2014-10-09T16:46:27.850

0

This:

Sub luxation()
    Dim s As String
    s = ThisWorkbook.Name
    MsgBox s
End Sub

will display something like:

Book1.xlsm

NOTE:

The Path is omitted, but the extension is included.
ThisWorkbook is the workbook containing the code.

edited Oct 09 '14 at 16:46

answered Oct 09 '14 at 16:29

Gary's Student

1 Answers1