I have created a vbscript that will scan an entire domain of computers, and
report a certain value about each one of these computers (ie the version of
a particular software installed). The script writes the data an Excel
spreadsheet. Because certain computers are not always on and the data is
changing, its difficult to get a full picture of the status of things with
only a snapshot of what's out there at any given time. So what I would like
to be able to do is take a previous spreadsheet and combine it with the
current report. The format of the spreadsheet is:
Computer1 Value1
Computer2 Value1
Computer3 Value2
...and so on.
I would like to know how to tell Excel preferably through vbscript, to match
and discard redundant values, and to keep differing values only from the
current report. So in the script I could specify a previous spreadsheet, and
using the example above, if the current value of "Computer1" now is
"Value2", and Computer2 is off, the spreadsheet will show the new value of
Computer1, and show the previously recorded value of Computer2. This way I
could keep a running tab of how an upgrade is going for an example. Any help
would be greatly appreciated.