set label value equal to file name

[ironj32]

anyone know how to set the value of a label equal to the workbook name?

me.lblSurveyName.value = ?

for example: "D:\DocumentsAndSettings\JLFOGEL\Desktop\"BIGSTORE.xls"

the label work display as BIGSTORE.

thanks!

[Charlize]

You said it yourself ...me.lblSurveyName.Caption = ThisWorkbook.NameCharlize

[ironj32]

lol. thanks!