XML reports an error when I close an excell workbook

[User_2010]

Why do I get the following error at the end of the TestStand execution if a close an excell workbook that I interact with using ActiveX/COM "Actions"?

[ Details:    An error occurred calling 'GetXML' in 'PropertyObject' of 'NI TestStandAPI 4.2'

Error code: -2147417836; User defined error code.
            Possible System Error. The requested object does not exist.

Location:   Step 'get XML for Result' of sequence 'AddReportBody' in 'reportgen_xml.seq']

If I DON'T close the workbook, TestStand will create a new one each time the sequence executes, and then crash on the third iteration.

If I select either "On-The-Fly Reporting" or a report format of "HTML Document" or "ASCII Document", the error goes away.

[Adam G]

Hello,

I was wondering if I could get you to make a sequence file that reproduces this error and then post it to the forums so I can take a look at it. This should give me a better idea of what is happening and also let me reproduce it on my end. Look forward to your response. Have a great day!

Best Regards,

Adam