Hello All,
I know how to use vbscript to open and populate an excel spreadsheet in a single write operation. But how do I do this if I want to do multiple write operations.
For example, I have a set of computers in a list held on a file, that I need to query for ceartain services. I would like to write the results to an excel file.
So the question is how do I keep a reference to the created excel sheet open with each new iteration of the list that holds the computer names? Also I need to keep a reference to the last written cell, so that new details as a computer is queried are written to the correct cell.
Has anybody done anything like this before? Any suggestions on how to proceed? I could do this if I was writing the results to an ordinary text file, but I need to write the results to an excel worksheet.
Any help would be fantastic. Cheers.
I know how to use vbscript to open and populate an excel spreadsheet in a single write operation. But how do I do this if I want to do multiple write operations.
For example, I have a set of computers in a list held on a file, that I need to query for ceartain services. I would like to write the results to an excel file.
So the question is how do I keep a reference to the created excel sheet open with each new iteration of the list that holds the computer names? Also I need to keep a reference to the last written cell, so that new details as a computer is queried are written to the correct cell.
Has anybody done anything like this before? Any suggestions on how to proceed? I could do this if I was writing the results to an ordinary text file, but I need to write the results to an excel worksheet.
Any help would be fantastic. Cheers.
