Tag: excel
231 script(s) tagged “excel”
Load Processor Info into Excel via WMI
Queries Win32_Processor via GetObject("winmgmts:") and dumps every Processor Info row straight onto the active workshee…
Export Video Controllers to CSV via WMI (VBA)
Queries Win32_VideoController via WMI and writes every Video Controllers row straight to a CSV file in Documents, using…
Apply Disable Tailored Experiences (VBA)
Stops Windows from using diagnostic data to personalize tips and ads. Applied via WScript.Shell.RegWrite from VBA.
Check Disable Tailored Experiences Registry Value (VBA)
Reads the Disable Tailored Experiences registry value via WScript.Shell.RegRead and reports it in a message box — no Po…
Check Enable Light Mode Registry Value (VBA)
Reads the Enable Light Mode registry value via WScript.Shell.RegRead and reports it in a message box — no PowerShell or…
Clean Up The current user's Temp folder (VBA)
Deletes every file in the current user's Temp folder after a confirmation prompt, using Scripting.FileSystemObject from…
Apply Disable First Logon Animation (VBA)
Skips the "Hi, we are setting things up for you" first-logon animation (requires admin). Applied via WScript.Shell.RegW…
Remove Hyperlinks from Sheet
Strips all hyperlinks from the active sheet while keeping the cell text and formatting intact.
Consolidate Sheets into One
Stacks the used range of every worksheet (except the destination) into one combined sheet, header row taken from the fi…
Report Size of The Windows Prefetch folder (VBA)
Reports the total size and top-level file count of the Windows Prefetch folder using Scripting.FileSystemObject, straig…
Load CD/DVD Drives into Excel via WMI
Queries Win32_CDROMDrive via GetObject("winmgmts:") and dumps every CD/DVD Drives row straight onto the active workshee…
Export USB Controllers to CSV via WMI (VBA)
Queries Win32_USBController via WMI and writes every USB Controllers row straight to a CSV file in Documents, using pla…