Topic Thread

Expand all | Collapse all

Copy and paste worksheet range issues

  • 1.  Copy and paste worksheet range issues

    Posted 05-14-2020 19:22
    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
    ------------------------------


  • 2.  RE: Copy and paste worksheet range issues

    Posted 05-15-2020 11:31
    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
    ------------------------------