Tag: excel
231 script(s) tagged “excel”
Apply Disable Balloon Tip Notifications (VBA)
Disables the small notification balloon tips in the system tray. Applied via WScript.Shell.RegWrite from VBA.
Apply Show This PC Icon on Desktop (VBA)
Adds the This PC icon back to the desktop. Applied via WScript.Shell.RegWrite from VBA.
Export Local User Accounts to CSV via WMI (VBA)
Queries Win32_UserAccount via WMI and writes every Local User Accounts row straight to a CSV file in Documents, using p…
AutoFit All Columns on All Sheets
Auto-fits column widths across every worksheet in the workbook in one pass.
Report Size of The Office document cache (VBA)
Reports the total size and top-level file count of the Office document cache using Scripting.FileSystemObject, straight…
Export Installed MSI Products to CSV via WMI (VBA)
Queries Win32_Product via WMI and writes every Installed MSI Products row straight to a CSV file in Documents, using pl…
Clean Up The npm cache (VBA)
Deletes every file in the npm cache after a confirmation prompt, using Scripting.FileSystemObject from Excel VBA. Locke…
Check Disable Explorer Startup Delay Registry Value (VBA)
Reads the Disable Explorer Startup Delay registry value via WScript.Shell.RegRead and reports it in a message box — no …
Report Size of The Windows Internet cache (INetCache) (VBA)
Reports the total size and top-level file count of the Windows Internet cache (INetCache) using Scripting.FileSystemObj…
List Files in The user CrashDumps folder (VBA)
Lists every file in the user CrashDumps folder with size and last-modified date directly on the active worksheet, using…
List Files in IIS log files (VBA)
Lists every file in IIS log files with size and last-modified date directly on the active worksheet, using Scripting.Fi…
Protect All Sheets
Applies sheet protection with a given password to every worksheet in the workbook.