Tag: excel
231 script(s) tagged “excel”
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…
Clean Up The VS Code cache folder (VBA)
Deletes every file in the VS Code cache folder after a confirmation prompt, using Scripting.FileSystemObject from Excel…
Apply Enable Light Mode (VBA)
Reverts File Explorer and other system surfaces to light mode. Applied via WScript.Shell.RegWrite from VBA.
Apply Disable Window Animations (VBA)
Disables minimize/maximize window animations for a snappier feel. Applied via WScript.Shell.RegWrite from VBA.
Check Disable Recent Documents History Registry Value (VBA)
Reads the Disable Recent Documents History registry value via WScript.Shell.RegRead and reports it in a message box — n…