cancel
Showing results for 
Search instead for 
Did you mean: 

Spy an open instance of Excel already open

PIdnani
Level 2
hi, I have application that exports data to excel, I've managed to automate everything until that point, however when I get to the excel part is where I cannot spy it... I have the MS excel VBO object already, but it does not have any actions of using an open workbook and then file - share attach as email, as this what I would like to do to finish this automation, any help is appreciated...
2 REPLIES 2

John__Carter
Staff
Staff
Try the Attach page to connect the Excel VBO to the open Excel instance.

sahana.mohan
Staff
Staff
Hi Pldnani,

The straightforward method is to save the workbook in local repository and use Email VBO to send mail with the excel file path as attachment. Let me know if it is workable for you, otherwise we need to use Code stage to perform actions on Excel which is not built within Excel VBO actions.

------------------------------
Sahana Mohan
Solution Designer
Blueprism
------------------------------
Sahana Mohan Lead Software Engineer SS&C Blue Prism