Inserting file name into a cell for EXCEL

[Mabocat]

I Googled this & came up with the archive of
http://www.mrexcel.com/archive/VBA/6851.html

good, I thought & followed it but it also includes the path & sheet name but I only want the file name.

Searching has proved difficult so has ony one answer please?

Ron

 

[Mabocat]

I found the answer here
http://office.microsoft.com/en-us/e...nt-excel-file-name-in-a-cell-HA001034627.aspx