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

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

as title says, want name of file saved string. have

wstitle = application.caller.worksheet.name

and forces n lower case , doesn't work.

this:

sub luxation() dim s string s = thisworkbook.name msgbox s end sub

will display like:

book1.xlsm

note:

the path omitted, extension included.thisworkbook workbook containing code.

excel vba excel-vba