π VBA
Visual Basic for Applications macros for Excel, Outlook, and other Office apps.
Unprotect All Sheets
Removes sheet protection from every worksheet in the workbook using a given password.
Load USB Controllers into Excel via WMI
Queries Win32_USBController via GetObject("winmgmts:") and dumps every USB Controllers row straight onto the active worβ¦
Export Contacts to CSV
Exports the default Outlook Contacts folder to a CSV file with Name, Email, Company, and Phone columns.
Check Disable Taskbar Chat Icon Registry Value (VBA)
Reads the Disable Taskbar Chat Icon registry value via WScript.Shell.RegRead and reports it in a message box β no Powerβ¦
Remove Duplicate Rows
Removes duplicate rows from the active sheet based on all used columns, keeping the first occurrence.
Check Show This PC Icon on Desktop Registry Value (VBA)
Reads the Show This PC Icon on Desktop registry value via WScript.Shell.RegRead and reports it in a message box β no Poβ¦
Check Disable Start Menu Suggested Apps Registry Value (VBA)
Reads the Disable Start Menu Suggested Apps registry value via WScript.Shell.RegRead and reports it in a message box β β¦
Report Size of The system-wide Windows Temp folder (VBA)
Reports the total size and top-level file count of the system-wide Windows Temp folder using Scripting.FileSystemObjectβ¦
Check Disable Start Menu App Suggestions Registry Value (VBA)
Reads the Disable Start Menu App Suggestions registry value via WScript.Shell.RegRead and reports it in a message box ββ¦
List Files in The Microsoft Teams cache (VBA)
Lists every file in the Microsoft Teams cache with size and last-modified date directly on the active worksheet, using β¦
Export CD/DVD Drives to CSV via WMI (VBA)
Queries Win32_CDROMDrive via WMI and writes every CD/DVD Drives row straight to a CSV file in Documents, using plain VBβ¦
Report Size of The Microsoft Teams cache (VBA)
Reports the total size and top-level file count of the Microsoft Teams cache using Scripting.FileSystemObject, straightβ¦