Prev: Range created using Union...accessing cells
Next: Assign a range to where the User Form places data
From: Janet Panighetti on 22 Dec 2009 17:10
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
From: Barb Reinhardt on 22 Dec 2009 17:49
Take a look at the BuiltInDocumentProperties to see if you can find what you
want there. I'm not sure you can get the "Owner", but you can find who last
modified the document.
--
HTH,

Barb Reinhardt



"Janet Panighetti" wrote:

> 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
From: Otto Moehrbach on 22 Dec 2009 17:49
Define the "owner". What are you looking for? HTH Otto

"Janet Panighetti" <JanetPanighetti(a)discussions.microsoft.com> wrote in
message news:376B5C94-7671-4E19-B5F6-14B8F6D7F47F(a)microsoft.com...
> 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

From: Barb Reinhardt on 22 Dec 2009 17:59
Take a look at the BuiltInDocumentProperties to see if you can find what you
want there. I'm not sure you can get the "Owner", but you can find who last
modified the document.
--
HTH,

Barb Reinhardt



"Janet Panighetti" wrote:

> 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
From: Gord Dibben on 22 Dec 2009 19:02
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"
<moehrbachoextra(a)bellsouth.net> wrote:

>Define the "owner". What are you looking for? HTH Otto
>
>"Janet Panighetti" <JanetPanighetti(a)discussions.microsoft.com> wrote in
>message news:376B5C94-7671-4E19-B5F6-14B8F6D7F47F(a)microsoft.com...
>> 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

 |  Next  |  Last
Pages: 1 2
Prev: Range created using Union...accessing cells
Next: Assign a range to where the User Form places data