How to find the owner of the active excel workbook
Maybe "Author" from Properties?
Sub test()
MsgBox ActiveWorkbook.BuiltinDocumentProperties("Author")
End Sub
Gord Dibben MS Excel MVP
On Tue, 22 Dec 2009 17:49:51 -0500, "Otto Moehrbach"
wrote:
Define the "owner". What are you looking for? HTH Otto
"Janet Panighetti" wrote in
message ...
Dear Smart People,
I'm sure this has been asked before but I'm not able to find the answer.
In Visual Basic, how may I find the name or system ID of the owner of the
currently active workbook?
I apologize if this is an "old" question but I've not been able to gleen
the
answer.
Thank you!
Janet
|