How do I modify account expiration dates in the UpdateWin2k spreadsheet? (NETIQKB50073)

goal
How do I modify account expiration dates in the UpdateWin2k spreadsheet?

goal
How can I modify the AccountExpirationDate account expiration property for multiple user accounts?

fact
Directory and Resource Administrator 7.x

fix

The UpdateWin2k spreadsheet enables you to retrieve from Active Directory properties from various classes, such as Computer, Contact, Group, OU, and User.  You can batch update multiple properties to Active Directory from this spreadsheet. 

The Directory and Resource Administrator (DRA) SDK includes the UpdateWin2k spreadsheet. For more information about the DRA SDK, see NETIQKB311, What is the Software Development Kit (SDK) and what can it do?

To modify the expiration dates for user accounts listed in the UpdateWin2k.xls spreadsheet:

1. Open the UpdateWin2k.xls file.

2. For each account with an expiration date you want to modify, change the value listed in the appropriate cell in the AccountExpirationDate column.

Notes:

• You can set the AccountExpirationDate value using the Excel date/time format or you can supply the date as a unicode value. 
• You can set the AccountExpirationDate value to Never Expire by entering a space or a zero (0) in the cell.
• You can update the UpdateWin2k.xls file manually or you can import values from another spreadsheet or csv file.

3. Save the UpdateWin2k.xls file.

Formerly known as NETIQKB50073