topic RE: Copy and paste worksheet range issues in Product Forum

Copy and paste worksheet range issues

MatteoPavone — Thu, 14 May 2020 18:22:00 GMT

Hello everyone!
I'm experiencing the following error while using the action on MS Excel VBO - Copy and paste worksheet range: failed to copy worksheet:error message: 'PasteSpecial method of Range class failed.

I'm actually using the action MS Excel VBO - Get number of rows to calculate the number of rows to paste and after I'm using the output of this action in "copy and paste..."

I am trying to copy around 1k rows/2k rows.

Can you suggest any valid alternative to copy and paste worksheet range action?

Thanks

------------------------------
Matteo Pavone
------------------------------

RE: Copy and paste worksheet range issues

John__Carter — Fri, 15 May 2020 10:31:00 GMT

Hi Matteo - try to make it work with a small range first, eg 10x20. If that works, then maybe it's something related to the volume of data.

Alternatively, in the Queue Reports object on the #Create Performance Report page, there is a code stage called Write Performance Data that might be helpful. You'll need to adapt the code but the technique (to populate an object array that you then write into a range) works well with large amounts of data.

http://portal.blueprism.com/system/files/vbos/Queue%20Reports.bprelease

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------