How to get Mail ID of Excel user - using VBA

Question

Hi All,

I want to get the Account information of Excel using , i.e When we click on "File" button which is top left side of Excel, we see something called "Account". In this "Account" we can see user mail id.

I want to capture user mail id using VBA.

Note: Application.Username will gives the system username which is not my requirement

This task is very important to me, your help in this regard highly appreciated

Regards,

Karthik

Answer 1

Hi Karthik,

AFAIK this information is not available in the VBA Office Object Model structure.

And you can not be sure to get this, cause not anybody is logged in:

And it is also possible to use more then one service.

But you can try to access the registry and enumerate all keys in this key:

HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Identity\Identities

Have also a look here:

https://technet.microsoft.com/en-us/library/dn151329.aspx

Andreas.

Answer 2

Thanks Andreas

Don't we have any alternative other than this. I mean using VBA ? 

Regards,

Karthik

Answer 3

Don't we have any alternative other than this. I mean using VBA ? 

Counter question: Why do you need that?

Andreas.

Answer 4

Andreas,

We have prepared one tool in Excel to our Architects/Project Managers, if they sign-in into Excel using Company credentials this tool should work otherwise (if they sign-in with into Excel with their personal id) it should not work.

So capturing their mail id is the only option i have.

Regards,

Karthik

Answer 5

We have prepared one tool in Excel to our Architects/Project Managers, if they sign-in into Excel using Company credentials this tool should work otherwise (if they sign-in with into Excel with their personal id) it should not work.

So capturing their mail id is the only option i have.

Forget it! It is not possible to protect an Excel file with VBA in a safe way!

Andreas.