Blue Prism Exam AD01 Topic 1 Question 80 Discussion

Actual exam question for Blue Prism's AD01 exam

Question #: 80
Topic #: 1

[All AD01 Questions]

Which of the following is the correct order to collect data using the Excel VBO?

AOpen Workbook > Get Worksheet as a Collection > Close Workbook

BShow Excel > Open Workbook > Get Worksheet as a Collection > Close Workbook

CCreate Instance > Open Workbook > Get Worksheet as a Collection > Close Workbook

DCreate Instance > Show Excel > Get Worksheet as a Collection > Close Workbook

Show Suggested Answer

Suggested Answer: C

Excel VBO Workflow:

The correct order to perform operations using the Excel VBO involves creating an instance, opening the workbook, performing actions (like getting the worksheet as a collection), and then closing the workbook.

Correct Order:

Create Instance: Initializes the Excel application instance.

Open Workbook: Opens the specified Excel workbook.

Get Worksheet as a Collection: Reads the worksheet data into a collection.

Close Workbook: Closes the workbook after operations are completed.

Blue Prism documentation on Excel VBO and its actions.

by Carin at Sep 16, 2024, 10:29 AM

Limited Time Offer

25%

Off

Get Premium AD01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Zona

12 days ago

I'll go with B. Showing Excel first makes it more user-friendly, and the rest of the steps seem logical.

upvoted 0 times

...

Margret

25 days ago

But creating an instance first makes more sense to me, so I still think C) is the correct order.

upvoted 0 times

...

Jovita

26 days ago

I disagree, I believe it is A) Open Workbook > Get Worksheet as a Collection > Close Workbook.

upvoted 0 times

...

Shalon

26 days ago

I think the correct answer is C. Creating an instance before opening the workbook makes sense, as you need an instance of Excel to work with.

upvoted 0 times

Mitsue

15 days ago

I agree, creating an instance before opening the workbook is the correct order.

upvoted 0 times

...

Tamekia

19 days ago

I think the correct answer is C.

upvoted 0 times

...

Margret

28 days ago

I think the correct order is C) Create Instance > Open Workbook > Get Worksheet as a Collection > Close Workbook.

upvoted 0 times

...