Do I need to run the range read workbook?

Help Activities
, ,
1

The run command does not work in the range read workbook. Is there any command that we need to use together to use it?
I saw youtube video that you use excel scope function together… I don’t see the function.

What parent commands do I need to run the range read workbook?

2

Hey

can you be more explicit, what do you need really?
if you just want to read an excel workbook use the read range activity
image

Regards

3

Hi,

Do you mean VBA run command? If so, ReadRange Workbook doesn’t support it.
Can you try to use ReadRange or ExecuteMacro with ExcelApplciationScope or ReadRangeX or RubSpreadSheetMacro with UseExcelFile?

image
image400×580 14 KB

Regards,

4

I want to retrieve the cell value in the Excel file from the clipboard without opening the Excel window.

5

Hi,

Can you try to use ReadCell Workbook activity as the following?

image
image1916×653 47.3 KB

Regards,

6

image
image1366×588 45 KB

Read Range Workbook: A column named ‘2303’ already belongs to this DataTable.

I’ve done it before.
The following error message appears

7

Hi,

Can you try ReadCell activity instead of ReadRange, as I menthioned?

Regards,

8

Wow! I succeeded! Thank you!