Add AD multi-value atributes Wednesday, Sep 9 2009 

Scripts canmo 08:49

Const ADS_PROPERTY_CLEAR = 1
Const ADS_PROPERTY_UPDATE = 2
Const ADS_PROPERTY_APPEND = 3
Const ADS_PROPERTY_DELETE = 4

‘Using PutEx to append addition values to multi-value attribute.
arrayValues(0) = CStr(3)
arrayValues(1) = CStr(4)
myObject.PutEx ADS_PROPERTY_APPEND, “myAttrib”, arrayValues

from: http://support.microsoft.com/kb/260251

So

objContainer.PutEx ADS_PROPERTY_APPEND, “member”, “CN=” & strUsername & “,” & strUserOU & “,” & strRootDSE   
objContainer.SetInfo

 

userAccountControl – AD account status Monday, Aug 31 2009 

Scripts canmo 11:47

Active directory stores a user’s account status in the userAccountControl field.  I find it’s easier to decode the Complete list of Codes by converting to binary.

Here are some common values:

       1000000000 - 512	Normal Account
       1000000010 - 514	Normal Account, Disabled
       1000100000 - 544	Normal Account, Password Not Req'd
       1000100010 - 546	Normal Account, Password Not Req'd, Disabled
10000001000000000	- 66048	Pwd never expires, Normal, Enabled
10000001000000010	- 66050	Pwd never expires, Normal, Disabled

 

VB Excel SaveAs Method FileFormat Constants Friday, Jul 24 2009 

Scripts canmo 09:44

 Using the excel.application worksheet.saveas method you need to know the constants

Ron mapped file extensions to FileFormat constant his site:

File Extension ".xlsb" --> XlFileFormat= 50
File Extension".xlsx"  --> XlFileFormat= 51
File Extension".xlsm"  --> XlFileFormat= 52
File Extension".xls"   --> XlFileFormat= 56
File Extension".csv"   --> XlFileFormat= 6
File Extension".txt"   --> XlFileFormat= -4158
File Extension ".prn"  --> XlFileFormat= 36

full list of XlFileFormat Enumeration

 

Next Page »