I opened an excel workbook using the PEGA new Excel connector. After making some manipulations, I again opened another excel workbook. When I connected the 'close' method, PEGA abruptly closes both the workbooks, instead of closing the current/active workbook.
So I don't have any choice and forced to use a script with INTEROP instead of PEGA automation tools.
Can anyone in PEGA suggest how to close the active workbook using the PEGA Automations tools?
Now reading Jeff's comments, I see that it is possible you are trying to open two documents with one connector? That would obviously perform as expected given your description. I assumed you meant you were opening a second document manually or otherwise outside of the connector. Is that not that case?