Tag: excel
231 script(s) tagged “excel”
Apply Disable Autoplay for All Drives (VBA)
Disables Autoplay prompts for every drive type, including USB. Applied via WScript.Shell.RegWrite from VBA.
Apply Disable Remote Assistance (VBA)
Disables the ability for others to remotely assist this PC (requires admin). Applied via WScript.Shell.RegWrite from VB…
Backup Workbook with Timestamp
Saves a timestamped copy of the current workbook next to the original, without disturbing the open file.
Load Physical Disk Drives into Excel via WMI
Queries Win32_DiskDrive via GetObject("winmgmts:") and dumps every Physical Disk Drives row straight onto the active wo…
Apply Disable Background Apps Globally (VBA)
Prevents Store apps from running in the background to save resources and battery. Applied via WScript.Shell.RegWrite fr…
Export Computer System Info to CSV via WMI (VBA)
Queries Win32_ComputerSystem via WMI and writes every Computer System Info row straight to a CSV file in Documents, usi…
Report Size of The Windows Update download cache (VBA)
Reports the total size and top-level file count of the Windows Update download cache using Scripting.FileSystemObject, …
Check Disable Taskbar Transparency Registry Value (VBA)
Reads the Disable Taskbar Transparency registry value via WScript.Shell.RegRead and reports it in a message box — no Po…
Export Environment Variables to CSV via WMI (VBA)
Queries Win32_Environment via WMI and writes every Environment Variables row straight to a CSV file in Documents, using…
List Files in The NuGet packages cache (VBA)
Lists every file in the NuGet packages cache with size and last-modified date directly on the active worksheet, using S…
Load Network Adapter Configuration into Excel via WMI
Queries Win32_NetworkAdapterConfiguration via GetObject("winmgmts:") and dumps every Network Adapter Configuration row …
Apply Disable Xbox Game Bar Capture (VBA)
Disables background game/app capture via the Xbox Game Bar. Applied via WScript.Shell.RegWrite from VBA.