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.
Nov 24, 2022 in Others by Kithuzzz
• 38,020 points
1,319 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 Nov 24, 2022 by narikkadan
• 63,680 points

Related Questions In Others

0 votes
1 answer

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

answered Jan 22, 2023 in Others by narikkadan
• 63,680 points
507 views
0 votes
1 answer
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, 2022 in Others by narikkadan
• 63,680 points
815 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, 2022 in Others by narikkadan
• 63,680 points
2,290 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
4,341 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
5,083 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
5,669 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
16,638 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, 2022 in Others by narikkadan
• 63,680 points
759 views
0 votes
1 answer

How can I count the rows with data in an Excel sheet?

With formulas, what you can do is: in ...READ MORE

answered Dec 27, 2022 in Others by narikkadan
• 63,680 points
567 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