MAKEMSI quickly and reliably creates MSI files in a non-programmatic way\Tips and TricksToolsScriptoMatic

---

ScriptoMatic

Not without its share of "features" but a very handy tool for testing WMI queries and getting the basic framework right. Apart from improvements mentioned below there is a major feature where it fails to list values and that is on values which may or may not contain an array. All such values should be generated via a function which takes care of the details (you would need to manually add this)...

Get more details and download it from "http://www.microsoft.com/technet/scriptcenter/tools/wmimatic.mspx".

Some similar tools:

• A ScriptoMatic type tool generating Power Shell code, also good WMI browser. (WMI browser & PowerShell code generator).
• TweakoMatic (Windows and IE settings)
• EZADScriptoMatic (active directory)

Suggested Fix 1

Replace the "WMIDateStringToDate()" function with the following routine which handles malformed dates rather than causing a trap:

Function WMIDateStringToDate(dtmDate)
   on error resume next
   WMIDateStringToDate = dtmDate
   if dtmDate <> "" then
       dim FmtDate
       err.clear()
       FmtDate = CDate(Mid(dtmDate, 5, 2) & "/" _
                 & Mid(dtmDate, 7, 2) & "/" & Left(dtmDate, 4) _
                 & " " & Mid (dtmDate, 9, 2) & ":" & Mid(dtmDate, 11, 2) _
                 & ":" & Mid(dtmDate,13, 2))
       if  err.number <> 0 then
           FmtDate = "<<Unexpected WMI date format>>"
       else
           FmtDate = "(" & FmtDate & " local time)"
       end if
       WMIDateStringToDate = WMIDateStringToDate & "    " & FmtDate
     end if
End Function

Please email me any feedback, additional information or corrections. See this page online (look for updates) MAKEMSI© is (C)opyright Dennis Bareis 2003-2008 (All rights reserved). Thursday August 28 2008 at 11:28am Visit MAKEMSI's Home Page