cancel
Showing results for 
Search instead for 
Did you mean: 

Copy and paste worksheet range issues

MatteoPavone
Level 3
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
------------------------------
1 REPLY 1

John__Carter
Staff
Staff
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
------------------------------