Hi,

Try

Title = ThisWorkbook.BuiltinDocumentProperties("Title")

If nothing has been entered then this will return Empty

Mike

"IanC" wrote:

If I hover the cursor over an Excel spreadsheet in Windows Explorer, a box
appears showing some of the file data. Included in this is the Title as
entered in the Properties page within Excel.

Can I find that file title using VBA without opening the file?

--
Ian
--