开发者

is there a way to check who has opened the macro?

开发者 https://www.devze.com 2023-01-09 17:15 出处:网络
i have an XLAM macro that runs as an add in. can i write a script in any language to identify the user (IP address or name of computer) who is curr开发者_Go百科ently using the macro??Why not?

i have an XLAM macro that runs as an add in. can i write a script in any language to identify the user (IP address or name of computer) who is curr开发者_Go百科ently using the macro??


Why not?
Use the Application.UserName property.

If that's not enough, then use the GetComputerName function:

Private Declare Function GetComputerName Lib "kernel32.dll" Alias "GetComputerNameA" (ByVal lpBuffer As String, ByRef nSize As Long) As Long
0

精彩评论

暂无评论...
验证码 换一张
取 消