Shorter way to paste from excel to word?

Help
1

Hi All,

Currently I’m using word application scope within excel application scope. After copying, (In word) I will
ctrl+g, do a series of send hotkeys to type in line tab, alt+f4 & paste. May I know if there’s any shorter
method to paste in specific line?

Suggestions are welcome!

2

use read range in excel application scope you will get the data table, and now use. output data able which give you data table as string now use write to word application.

3

You can use Replace Text activity.

  • Provide a Syntax in Word document like %%ReplaceText%%.
  • Use Replace Text activity to replace it with required text. You can give new lines using Environment.Newline.

image

1 Like
4

I’m trying to paste a table/chart(below the replaced text) after replacing text, I tried using newline & send hotkey enter, ctrl v but it always pastes on top?

5

For Tables, you can use insert Datatable activity by replacing a keyword. You need to mention position as “Replace” and provide relace text.
image

image

5 Likes
6

This is what I needed, much thanks!

7

Either way, is there a way I can replace text or chart(in word) with a chart I just created in excel?

8

Please see the below link.

9

If you got solution please mark it as solved :slightly_smiling_face: