get machine specific from network

I

iccsi

I need collect all machines information like machine name, IP address, RAM, CPU, from network.

Are there any function or API or example code to do this?

Your help and information is great appreciated,

iccsi
 
Joined
Aug 31, 2012
Messages
4
Reaction score
0
Found this before but you'd need to do it using Excel and add it as a macro then activate.

You can use some of the keywords from what it pulls up into the Sheet1 as a reference and use the Environ(""") command in VB to pull up that specific item. For example using VB you can find the username of the currently logged on user by coding Environ("username"). You can then use that string to display it on things like MsgBox's and unbound fields.

----------------------------------------------------------------
Sub Environ_Check()
Dim r As Long
Dim P As Long
r = 1
Do
Cells(r, 1) = r
Cells(r, 2) = Environ$(r)
P = InStr(1, Cells(r, 2), "=")
Cells(r, 3) = Left$(Cells(r, 2), P - 1)
' 'or the following with Excel 2000
' Cells(r, 3) = Split(Cells(r, 2), "=")(0)
r = r + 1
Loop Until Len(Environ$(r)) = 0
Columns("A:B").AutoFit
[A1].Select

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\u74evr\My Documents\Environ.xls", FileFormat:= _
xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
Application.Run "Environ.xls!Environ_Check"
Range("B16").Select
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.SmallScroll ToRight:=1
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Range("B17").Select
ActiveWindow.SmallScroll Down:=10
Range("B35").Select
ActiveWindow.SmallScroll Down:=10
Range("B39").Select
ActiveWindow.SmallScroll Down:=-110
ActiveWorkbook.Save

-----------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top