Failed to paste from clipboard: PasteSpecial method of Range class failed

[Soumya21]

Hi

I am trying to use MS Excel VBO Actions to select, copy and paste while pasting I am getting the Failed to paste from clipboard: PasteSpecial method of Range class failed. When I am executing in debug mode its working fine but while executing in control room it is throwing the above error sometimes
I have used actions Activate worksheet, Select, Copy, Go to Cell, Paste.
I am also getting RPC error. Can anyone explain the reason behind RPC error and solution
Kindly please let me know any solutions for this.



------------------------------
Soumya kalal RPA Developer
------------------------------

[Soumya21]

Hi @ewilson

copy/paste exception doesn't depend on RPC error.
the RPC error message states that Could not execute code stage because exception thrown by code stage: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

Thanks,
Soumya
​

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

[ewilson]

Thanks for the clarification @Soumya21. In either case, your approach of catching the error and then retrying is a god approach. I will try to recreate the copy/paste issue to see if we can figure out what's going on there.

Cheers,
​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[Soumya21]

Hi @ewilson

Is there any issue in Paste action in excel VBO,
Before I used to get errors, in particular some paste actions, but now, I am facing issues with all paste actions wherever used in the entire process it occurs at various stages and not in the fixed stage.
Please help me to resolve this issue

Thanks,
Soumya



​​​

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

[ewilson]

Hello @Soumya21,

​You stated that you're performing "Select, copy, go to cell, paste". Is the data that you're copying contained in a single cell? When you go to the new cell what action are you using? Is it another Select?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[Soumya21]

Hi @ewilson
No. I am selecting whole column data and pasting in another ​column (go to cell, Paste actions)

Thanks,
Soumya


------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

[ewilson]

@Soumya21,

​Ok. Please try changing the flow of your process to perform a select on the source column and then copy. After that perform a select on the destination column and then paste. Here's an example of what I'm describing:


This works fine for me.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------