Thanks John - very useful
James
"John.Greenan" wrote:
Hi James,
Try this....
sub test()
dim strNameOfAuthor as string
strNameOfAuthor = ThisWorkbook.BuiltinDocumentProperties("Author")
msgbox "The Author name is " & cstr(strNameOfAuthor)
end sub
--
www.alignment-systems.com
" wrote:
Does anyone know how to programatically (using VBA) find the author of a file
(File menu, Properties and Author) as I can't record it or find it in the
object browser