The code gives the name of the VB file, not the excel
file. Is there a way to give the name of the excel file?

???????

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


--
----------------------------
Mauro Gamberini