ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 155 - AD01 discussion

Report
Export

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

A.
Open Workbook > Get Worksheet as a Collection > Close Workbook
Answers
A.
Open Workbook > Get Worksheet as a Collection > Close Workbook
B.
Show Excel > Open Workbook > Get Worksheet as a Collection > Close Workbook
Answers
B.
Show Excel > Open Workbook > Get Worksheet as a Collection > Close Workbook
C.
Create Instance > Open Workbook > Get Worksheet as a Collection > Close Workbook
Answers
C.
Create Instance > Open Workbook > Get Worksheet as a Collection > Close Workbook
D.
Create Instance > Show Excel > Get Worksheet as a Collection > Close Workbook
Answers
D.
Create Instance > Show Excel > Get Worksheet as a Collection > Close Workbook
Suggested answer: C

Explanation:

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.

asked 16/09/2024
Jess Kendrick Gamboa
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first