Re: Eksport użytkowników z domeny do pliku *.txt

Autor: hehehehe <ehhehe_at_ccc.ccc>
Data: Tue 30 Sep 2008 - 11:56:40 MET DST
Message-ID: <gbst4p$2f9n$1@news2.ipartners.pl>

stworz sobie jakis pliczek z rozszerzeniem *.vbs i wklej to :

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.Add
intRow = 2
objExcel.Cells(1, 1).Value = "User Name"
objExcel.Cells(1, 2).Value = "Full Name"
objExcel.Cells(1, 3).Value = "Description"
objExcel.Cells(1, 4).Value = "Account Disabled"
objExcel.Cells(1, 5).Value = "When Created"

strDomain = InputBox ("Enter Domain Name")
Set DomObj = GetObject("WinNT://" & strDomain )
DomObj.Filter = Array("User")
For Each objUser In DomObj
objExcel.Cells(intRow, 1).Value = objUser.Name
objExcel.Cells(intRow, 2).Value = objUser.FullName
objExcel.Cells(intRow, 3).Value = objUser.Description
objExcel.Cells(intRow, 4).Value = objUser.AccountDisabled
objExcel.Cells(intRow, 5).Value = objUser.whenCreated
intRow = intRow + 1
Next
objExcel.Range("A1:E1").Select
objExcel.Selection.Interior.ColorIndex = 19
objExcel.Selection.Font.ColorIndex = 11
objExcel.Selection.Font.Bold = True
objExcel.Cells.EntireColumn.AutoFit
wscript.echo "Done"

powinno pomóc
Received on Tue Sep 30 12:01:07 2008

To archiwum zostało wygenerowane przez hypermail 2.1.8 : Tue 30 Sep 2008 - 12:42:02 MET DST