πŸ“Š VBA

Visual Basic for Applications macros for Excel, Outlook, and other Office apps.

πŸ“Š VBA (Excel)

Unprotect All Sheets

Removes sheet protection from every worksheet in the workbook using a given password.

πŸ“Š VBA (Excel)

Load USB Controllers into Excel via WMI

Queries Win32_USBController via GetObject("winmgmts:") and dumps every USB Controllers row straight onto the active wor…

πŸ“Š VBA (Excel + Outlook)

Export Contacts to CSV

Exports the default Outlook Contacts folder to a CSV file with Name, Email, Company, and Phone columns.

πŸ“Š VBA (Excel)

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…

πŸ“Š VBA (Excel)

Remove Duplicate Rows

Removes duplicate rows from the active sheet based on all used columns, keeping the first occurrence.

πŸ“Š VBA (Excel)

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…

πŸ“Š VBA (Excel)

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 β€” …

πŸ“Š VBA (Excel)

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…

πŸ“Š VBA (Excel)

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 —…

πŸ“Š VBA (Excel)

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 …

πŸ“Š VBA (Excel)

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…

πŸ“Š VBA (Excel)

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…