MS Excel VBO

SHANMUGA_PRIYAM — Sat, 15 Apr 2023 12:42:54 GMT

I am using Blue Prism version 7.1.2. In MS Excel VBO under get worksheet as collection i could see a input - Fetch Data With Method. What are the methods that are supposed to be given here ?

Re: MS Excel VBO

Mukeshh_k — Sat, 15 Apr 2023 15:00:24 GMT

Hi SHANMUGA PRIYA MANI - Theses are properties of Range Object - You can pass the method as Text, Value or Value2, refer below :

.Text gives you a string representing what is displayed on the screen for the cell. Using .Text

.Value gives you the same as .Value2 except if the cell was formatted as currency or date it gives you a VBA currency (which may truncate decimal places) or VBA date.
.Value2 gives you the underlying value of the cell (could be empty, string, error, number (double) or boolean)

For more on these you can find Microsoft documentation below -
https://learn.microsoft.com/en-us/office/vba/api/excel.range.text
https://learn.microsoft.com/en-us/office/vba/api/excel.range.value
https://learn.microsoft.com/en-us/office/vba/api/excel.range.value2

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------

topic MS Excel VBO in Product Forum

MS Excel VBO

Re: MS Excel VBO