How can I store the data of an open excel workbook in a collection using BluePrism

0 votes
I can open an Excel workbook with just a click of a button in another program. Now that the excel file has been saved, I want to put the workbook's data in a collection instead. The workbook's name is dynamically altered. How can I save the workbook's data in a collection?

I've already tried using the 'Get Worksheet as Collection' Action stage with the Excel VBO Business Object, but nothing happens because I have no idea what to enter for the workbook name.
3 days ago in Others by Kithuzzz
• 20,660 points
8 views

1 answer to this question.

0 votes

To do what you want is like this:
enter image description here

Regardless of the name of the workbook, the MS Excel VBO action "Attach" will attach to any instance of Excel that is currently open. The "handle" data item will be output, which you may utilize with the "Get Worksheet as Collection" action.
In this manner, there is no need to save the file. However, keep in mind that if you are running multiple instances of Excel, this will not work.

answered 3 days ago by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How do I protect all worksheet in an Excel workbook with a single click?

VBA Code : Dim ws as Worksheet Dim pwd ...READ MORE

answered Oct 22 in Others by narikkadan
• 37,660 points
29 views
0 votes
1 answer

How can I sort one set of data to match another set of data in Excel?

In addition, INDEX MATCH is a more ...READ MORE

answered Oct 29 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer

How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

answered Nov 7 in Others by narikkadan
• 37,660 points
25 views
0 votes
1 answer

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

answered Nov 11 in Others by narikkadan
• 37,660 points
30 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,365 views
0 votes
0 answers

How to use Global Send Keys in Excel in Blueprism

Hi, I have material copied to the ...READ MORE

Apr 4, 2019 in RPA by Ishan
3,762 views
0 votes
1 answer

What is code segment in Blueprism and how to implement it?

Blue Prism - Code Stage The code stage ...READ MORE

answered Sep 28, 2018 in RPA by Priyaj
• 58,100 points
4,613 views
0 votes
1 answer

Error : Failed to perform step 1 in Navigate Stage '-----' on page '----' - Not Connected

Do you have Attach bookmark created? When ...READ MORE

answered Sep 28, 2018 in RPA by Priyaj
• 58,100 points
14,311 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
57 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP