Tag: excel
231 script(s) tagged “excel”
Check Increase Icon Cache Size Registry Value (VBA)
Reads the Increase Icon Cache Size registry value via WScript.Shell.RegRead and reports it in a message box — no PowerS…
Check Hide Taskbar Search Box Registry Value (VBA)
Reads the Hide Taskbar Search Box registry value via WScript.Shell.RegRead and reports it in a message box — no PowerSh…
Load Network Shares into Excel via WMI
Queries Win32_Share via GetObject("winmgmts:") and dumps every Network Shares row straight onto the active worksheet, n…
Check Disable Windows Welcome Experience Registry Value (VBA)
Reads the Disable Windows Welcome Experience registry value via WScript.Shell.RegRead and reports it in a message box —…
Check Show Seconds in Taskbar Clock Registry Value (VBA)
Reads the Show Seconds in Taskbar Clock registry value via WScript.Shell.RegRead and reports it in a message box — no P…
List Files in The npm cache (VBA)
Lists every file in the npm cache with size and last-modified date directly on the active worksheet, using Scripting.Fi…
Convert Formulas to Values
Replaces every formula in the used range of the active sheet with its calculated value.
List Files in The Windows Prefetch folder (VBA)
Lists every file in the Windows Prefetch folder with size and last-modified date directly on the active worksheet, usin…
Export Network Adapters to CSV via WMI (VBA)
Queries Win32_NetworkAdapter via WMI and writes every Network Adapters row straight to a CSV file in Documents, using p…
Check Enable Num Lock on Startup Registry Value (VBA)
Reads the Enable Num Lock on Startup registry value via WScript.Shell.RegRead and reports it in a message box — no Powe…
Load Network Login Profiles into Excel via WMI
Queries Win32_NetworkLoginProfile via GetObject("winmgmts:") and dumps every Network Login Profiles row straight onto t…
Apply Disable Sticky Keys Shortcut Prompt (VBA)
Stops the Sticky Keys dialog from popping up when Shift is pressed 5 times. Applied via WScript.Shell.RegWrite from VBA.