Merging task RRS feed

  • Question

  • Hi,

    I have a took that creates an XML file from a vulnerability scan which can be opened by Excel.  This workbook has 5 different tabs with data organized in different formats.  One of the worksheets is called "Details" which is the one I want for my task.

    The problem now is, we run the vulnerability scan on 200+ machines and we have 200+ XML workbooks.  Is there anyway I can extract that one "Details" worksheet from each system and create a single worksheet with all the information?  I am willing to write some code but don't know where to start.

    Any help and advise is appreciated.

    Thank you in advance.


    Tuesday, October 11, 2011 1:11 PM