Marco to get Windows sessions + machine

[graiggoriz]

Hello,

I am using a excel file to gather information from IT guys. Instead of requesting to enter their username and hostname, I was wondering if I could use a macro that would get the windows session and the windows username (cmd > hostname).

FYI. I already use a macro to record information.

If you need further infor please let me know. I use excel 2010

Graig

[graiggoriz]

I have seen this article that would pretty much match what I need.. But I need the username and hostname copied in the A2 and B2 cells..

Here is the macro:

I did not get how that macro should be used.. Any help would be more than welcome

[Fotis1991]

I am wondering-as you didn't feed back - if your problem in this thread was solved!

[alansidman]

Please Login or Register  to view this content.

Add the lines in Red to your code and install as below

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[graiggoriz]

@ Fotis1991: I've just provided my feedback.
@ alansidman: Thank you. I do know how to run the macro but I do not know how to manage to have the username in B1 cell and hostname in the B2 cell.

[alansidman]

graiggoriz;
BTW the dollar sign ($) after the Environ is extraneous as you have already declared sUserName and sHostName as Strings.

[graiggoriz]

I really do not get how that macro work! I did remove the $ before Environ..

My goal is to get the username in B1 and hostname in B2

I attache the file in case I miss a step (at least to run macro I found which will not give m e exactly what I wish).

Thanks,
Graig

[alansidman]

I checked your code. You did not add in the lines of code that I highlighted in RED in post #4. This will add the items as you requested.