Get name of workbook calling a common .xla on network drive

[coderxl]

We have several workbooks on user machines which all access a common library .xla file residing on a network drive.

We need to add logging functionality in the xla addin, which will log the name of the workbook that is making any call to the sub/function in the .xla and the username who is using the workbook. How do we get the workbook name and username from within the xla?

[DonkeyOte]

Regards File Name invoking the call - assuming invoked from a cell:

Please Login or Register  to view this content.

Regards username

Please Login or Register  to view this content.

[coderxl]

Thanks. But the code to get the workbook name does not work. Application.Caller.Parent is null. Please note that my workbook has a button which is bound to a macro defined in the workbook. This macro then makes a call to the add-in function. While debugging, I found that Application.Caller is the button object, but Application.Caller.Parent is null.
Also what is the difference between Environ("username") and Application.UserName ?

[romperstomper]

If it's triggered by button click, then just Activeworkbook.name should work. As regards user names, environ gives you the network login, whereas application.username gives you whatever has been entered in Excel options.

[coderxl]

Thanks. It works fine.