Excel open by another application

[RPAVienna]

Hi all,

I'm trying to get range from an open excel. This isnt a problem with "usual" excel files. However I use another internal program which holds the excel file in it's database. Once I open the excel file through the other application the blue prism excel vbo's do not work.

Can somebody help? It would be sufficient to get a range of data out of it.
It seems that I cannot attach to the excel file because it is opened through another application.

Im happy about every help.

Best regards,
Lukas

 

[sahil_raina_91]

Excel VBO provides an action to attach to already opened Workbook. The output of that action is Handle.
Have you tried using that ?

Alternatively, you can create a new object, attach to excel process.
Activate & Focus the Workbook
Send CTRL+A / CTRL + C
Get Data from Clipboard

 

[RPAVienna]

Hi,
Thank you for responding to my topic.
Yes, Ive tried to attach to the excel and give the handle number to the following actions. However, I think the attach did not work because I did not create a new vbo.
I will try your suggestions in phase 2 of the bot as it is much more sophisticated as my workaround.
Thank you in advance!