how to return a filename from a cell to msgbox

[dmcgov]

i have the following code:

Please Login or Register  to view this content.

but the msgbox just returns a blank dialog box, how can i get the current filename to display and use it in a vba statement?

[dmcgov]

i did this instead

Please Login or Register  to view this content.