Read currently open file name in excel

[M0E-lnx]

Does anyone know of a way to read the name of the currently open file in excel using VBA?

I've tried the Application.Getopenfilename, but that brings up the Open file dialog which I do not want.

If I'm editing a file called "Sample-sheet.xls" I need a way to find that string in VBA

Any ideas?

 

[M0E-lnx]

Never mind All, I just found the ActiveWorkbook.Name which provided what I needed.