Simple VBA code to translate, in an Excel file, UserAccountControl flags from their decimal value to a human readable value. This code is designed to work best with CSV/Excel template report from Detack appliance. You can simply customize the column header with the UAC flags by renaming "spare_big_1" in the code with the actual column header name you are looking for.

To better understand what UAC Property flags mean please refer to well documented Microsoft site: https://docs.microsoft.com/en-us/troubleshoot/windows-server/identity/useraccountcontrol-manipulate-account-properties. Some other references can be more detailed and applicable to your daily work, like: http://www.selfadsi.org/ads-attributes/user-userAccountControl.htm.

Quick note about flag PASSWD_NOTREQD: This flag is often misunderstood. If means that the user is not subject to a possibly existing policy regarding the length of password. So, the user can have a shorter password than required or even an empty password.

How to use:
Open with Excel the desired CSV/Excel file that contains the UAC values in a column
Select the desired worksheet/tab file that contains the UAC values (the macro will use the active worksheet)
Select View -> Macros
Type "UAC" in the "Macro name" field (without the "")
Then select "Create"
Copy paste the full code, make sure to erase the "Sub UAC() End Sub" already present
Select depending on your habits "Run"->"Run Sub" / "F5" / the green play button
The results will be written in the column right after the column containing the UAC values (expect 1 second per 200 lines)
You can then save your Excel file, there is no need to register the macro unless you want to do so