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

Activeworkbook.BuiltinDocumentProperties("author")

--
HTH

Bob Phillips

" m
wrote in message ...
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

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

Thanks Bob that was very helpful


"Bob Phillips" wrote:


Activeworkbook.BuiltinDocumentProperties("author")

--
HTH

Bob Phillips

" m
wrote in message ...
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

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