Add and Remove from collection using Excel VBA

This is crude and unfinished but I wanted to post it ASAP so I don't lose it.   [Excel VBA code] Option Explicit Sub ConnectWMIServer() ' version 1.1.0.0 ' Author Roger 7/19/2017 Const wbemFlagReturnImmediately = &H10 Const wbemFlagForwardOnly = &H20 Dim objWMIService, StrQuery, ColItems, objItem Dim objSmsNewRule, objSMS_Collection Dim ComputerName: ComputerName = "XX6761" Dim CollectionID: … Continue reading Add and Remove from collection using Excel VBA

Remove app, install MS Updates, install app

This is for a particular app that had some update requirements. @Echo on REM Uninstall ININ / ICIC elements, apply MS patches, Install latest ININ / ICIC elements REM 26-Jun-2017 REM Roger C. Set MyVer=1.8.1.0 Set MyError=NO Set MyWarning=NO set DEBUGGING=NO Call :InitLog if "%DEBUGGING%"=="YES" @echo on REM ============================================================== REM Set some required variables based … Continue reading Remove app, install MS Updates, install app