Need excel 2010 Macro wmi to extract username from wmi?

Asked By Dennis Azal 30 points N/A Posted on - 09/16/2012

I need a excel 2010 macro wmi to help me extract username from wmi.

I have windows 7 and office 2010 on my laptop.

• Status: Open
• Question Views: 1364
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sharath Reddy

Go To Solution

Answered By Niktha Busch 0 points N/A #156966

Need excel 2010 Macro wmi to extract username from wmi?

Hey Dennis,

You should do the following-

1. Change the USER21 Macro with $ARG1$ by typing in the command – ch wig $ARG1$.

2. Then replace by writing – mv wig uspl

4. A window will appear. Click apply to host and close the terminal.

And you will be able to extract.

 

About Niktha Busch

Questions
1

Answers
100

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 09/25/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #156967

Need excel 2010 Macro wmi to extract username from wmi?

I tried searching for a Microsoft Office Excel macro that can be used to extract usernames in WMI files.

I found several macros on my search and here is one of the macros I found that might help you in extracting some information on WMI files.

Function GetFullName() As String
    Dim computer As String
    computer = "."
    Dim objWMIService, colProcessList As Object
    Set objWMIService = GetObject("winmgmts:\" & computer & "rootcimv2")
    Set colProcessList = objWMIService.ExecQuery _
        ("SELECT * FROM Win32_Process WHERE Name = 'EXCEL.EXE'")
    Dim uname, udomain As String
    Dim objProcess As Object
    For Each objProcess In colProcessList
        objProcess.GetOwner uname, udomain
    Next
    GetFullName = UCase(udomain) & "" & UCase(uname)
End Function

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 01/16/2013
• Question Category: MS Excel