Copying data from word to Excel - Error

[danniaus1]

Hello

I am wanting to open a PDF in word, copy the data from word and paste into an excel spreadsheet. I will then create a collection from this spreadsheet

I have created the following process

View attachment 1560738036880.png

The issue I am having is that the following errors occur

View attachment 1560738162812.png

I am not sure what I am doing incorrectly.

 

[Sachin_Kharmale]

May be ,
1)Handle Value mismatch
2)check for all Excel and Ms Word operation you have use same VBO it might be
For create instane - Excel Object 1
And for open workbook - Excel object 2
2)check Excel Handle and Word Handle store in different Data item do not use common Data item to store and Handle and any other informations of both Object may be it will conflict due to that the error comes the given key is not present in dictionary.

 

[danniaus1]

May be ,
1)Handle Value mismatch
2)check for all Excel and Ms Word operation you have use same VBO it might be
For create instane - Excel Object 1
And for open workbook - Excel object 2
2)check Excel Handle and Word Handle store in different Data item do not use common Data item to store and Handle and any other informations of both Object may be it will conflict due to that the error comes the given key is not present in dictionary.

Thanks Sachin

I have checked and the handles are all correct.

I have run again and now this is the error I am getting

Your help is appreciated

View attachment 1560745298776.png

 

[Sachin_Kharmale]

The error came to that step stop with break point
Open new word or excel manually and paste clipboard data into word or excel to check the content of clipboard data
may be clipboard does not contains data

Paste Special method range class failed -
Check you are passing the right Range to action like "A1:B5"