Contributions
Native Excel Object - How to Close
Hi all, I am using the native Excel object in TestComplete. The object has methods for creating, opening and saving files. However, I am infrequently encountering the following issue when attempting to open an Excel file. The file is not being used by another process (Microsoft Excel is not installed on the machine and no other program apart from TestComplete is being used to access the file). Is it possible to initialize the Excel object, or to close an opened file? As I mentioned above, there does not seem to be a method for closing - only creation, opening and saving. Any help would be greatly appreciated.513Views0likes2CommentsHow To Export Multiple Existing Test Logs as MHT
Hi there! I am trying to implement what I feel should be an easy solution. (I will just pre-empt this by saying I know you can add an event to call Log.SaveResultsAs() to generate an MHT file of the currently running test OnStop etc, but I cannot modify events as it will greatly impact our test running time for CI if MHT files are generated after each test case (our cases are quite long). Of course its a trade-off we can make, but I wanted to see if I could do something else instead!) Here as an example I have multiple logs for test runs that havealready occurred. (I cant find an equivalent Log/slPack method to export pre-existing Logs to MHT, only currently running tests.) If I right click onone of these, I have the option to Export Logs. However, it seems that I cannot bulk export them - I only have an option to Remove if I select more than one. It is not that I want to export all of these different logs into one MHT file (that wouldn't make sense!), I just wish to be able to select multiple files, and have them all exported to their own MHT files at some desired location. I have tried to do this programmatically as I mentioned, but I cannot find a means of exporting already existing logs. Any advice for this seemingly simple task would be greatly appreciated! Kind Regards, PJSolved1.5KViews0likes2Comments