get a range from an Excel Sheet and past it into a Word table

[absak]

hello,

had anyone tryed to copy a range from a Excel Sheet to Word document table:

i guess it is using the following flow:

get range as collection activity in the Excel VBO.

but which activity to use in the Word VBO.

 

[mohan12]

Use msword vbo import from blue prism folder

 

[absak]

which activity to use? i get the Ecxel data into collection but how to wrrite it into a table in a Word document.

 

[VJR]

hello,

had anyone tryed to copy a range from a Excel Sheet to Word document table:

i guess it is using the following flow:

get range as collection activity in the Excel VBO.

but which activity to use in the Word VBO.

Hi absak,
- Use the 'Select' action of MS Excel VBO to highlight all your data that needs to be copied
- 'Copy' action
- 'Create instance' of the Word document (this can also be done at the beginning of the process)
- 'Open'
- 'Show' (optional)
- 'Paste from Clipboard' action of MS Word VBO

View attachment 1543567162873.png