📊 VBA
Visual Basic for Applications macros for Excel, Outlook, and other Office apps.
Highlight Duplicate Values
Highlights duplicate values within the current selection using conditional formatting-style fill color.
List Files in The Windows Internet cache (INetCache) (VBA)
Lists every file in the Windows Internet cache (INetCache) with size and last-modified date directly on the active work…
Load Signed Drivers into Excel via WMI
Queries Win32_PnPSignedDriver via GetObject("winmgmts:") and dumps every Signed Drivers row straight onto the active wo…
Load Processes into Excel via WMI
Queries Win32_Process via GetObject("winmgmts:") and dumps every Processes row straight onto the active worksheet, no P…
Apply Enable Num Lock on Startup (VBA)
Turns Num Lock on by default for every new sign-in. Applied via WScript.Shell.RegWrite from VBA.
Export Time Zone Settings to CSV via WMI (VBA)
Queries Win32_TimeZone via WMI and writes every Time Zone Settings row straight to a CSV file in Documents, using plain…
Export Network Shares to CSV via WMI (VBA)
Queries Win32_Share via WMI and writes every Network Shares row straight to a CSV file in Documents, using plain VBA fi…
Load System Drivers into Excel via WMI
Queries Win32_SystemDriver via GetObject("winmgmts:") and dumps every System Drivers row straight onto the active works…
Apply Disable Recent Documents History (VBA)
Stops Windows from tracking recently opened documents. Applied via WScript.Shell.RegWrite from VBA.
Report Size of The npm cache (VBA)
Reports the total size and top-level file count of the npm cache using Scripting.FileSystemObject, straight from Excel …
Load Environment Variables into Excel via WMI
Queries Win32_Environment via GetObject("winmgmts:") and dumps every Environment Variables row straight onto the active…
Export Services to CSV via WMI (VBA)
Queries Win32_Service via WMI and writes every Services row straight to a CSV file in Documents, using plain VBA file I…