Tag: excel
231 script(s) tagged “excel”
Load Sound Devices into Excel via WMI
Queries Win32_SoundDevice via GetObject("winmgmts:") and dumps every Sound Devices row straight onto the active workshe…
Check Disable Taskbar Widgets Icon Registry Value (VBA)
Reads the Disable Taskbar Widgets Icon registry value via WScript.Shell.RegRead and reports it in a message box — no Po…
Export All Sheets to CSV
Excel VBA module that exports every worksheet in the active workbook to its own UTF-8 CSV file automatically.
Outlook Inbox to Excel
Pulls Subject, Sender, Received time, and Unread status from your Outlook Inbox straight into an Excel sheet via COM au…
Apply Disable Aero Shake (VBA)
Stops shaking a window from minimizing every other open window. Applied via WScript.Shell.RegWrite from VBA.
Export Connected Monitors to CSV via WMI (VBA)
Queries Win32_DesktopMonitor via WMI and writes every Connected Monitors row straight to a CSV file in Documents, using…
Load Time Zone Settings into Excel via WMI
Queries Win32_TimeZone via GetObject("winmgmts:") and dumps every Time Zone Settings row straight onto the active works…
Add Timestamp to Active Cell
Inserts the current date and time into the active cell — handy bound to a keyboard shortcut for quick logging.
Export Network Adapter Configuration to CSV via WMI (VBA)
Queries Win32_NetworkAdapterConfiguration via WMI and writes every Network Adapter Configuration row straight to a CSV …
List Files in The Office document cache (VBA)
Lists every file in the Office document cache with size and last-modified date directly on the active worksheet, using …
Export Startup Programs to CSV via WMI (VBA)
Queries Win32_StartupCommand via WMI and writes every Startup Programs row straight to a CSV file in Documents, using p…
Apply Align Taskbar Icons Left (VBA)
Switches the Windows 11 taskbar back to left-aligned icons. Applied via WScript.Shell.RegWrite from VBA.