Showing posts with label Win32_ComputerSystem. Show all posts
Showing posts with label Win32_ComputerSystem. Show all posts

Saturday, 1 November 2014

WMI, VB.classic & Excel

On this blog, posts about Microsoft software are as rare as Rocking Horse sh manure. But I have to get my hands dirty for a few hours each week, in my part-time network support job.


Although VB.classic (aka VB6) was replaced many years ago by VB.net, it lives on in the form of VBA (Visual Basic for Applications).


And if I need to gather information about networked Windows computers, I like to write VB code within Excel, and draw on the power of WMI (Windows Management Instrumentation).