Community Chat

last person joined: yesterday 

A space for discussion around the Community site and programs.

  • 1.  Unable to Perform Control V(Paste) in Excel

    Posted 10-24-2021 21:28
    I copied some records from a third party application into my clipboard using Blueprism and the next step is to paste these records into excel. If manually pasted into Excel using CTRL V, these records are populated into different rows in excel automatically. 
    However, if I try using PASTE in EXCEL VBO, it gives an error which states " PasteSpecial method of Range class failed". 
    Also, if I use Set cell value, it pastes these values in just one row.
    I need help in resolving this challenge.

    Thank you.

    ------------------------------
    Shakirat Jimoh
    RPA Developer
    Waje Smart solutions
    Africa/Lagos
    ------------------------------


  • 2.  RE: Unable to Perform Control V(Paste) in Excel

    Posted 10-25-2021 06:08
    Hi Shkriat,

    You have to manipulate code a little bit. PFB image for more clarification do let me know if you have any further issue


    ------------------------------
    Amlan Sahoo
    RPA Consultant
    Equinix
    ------------------------------



  • 3.  RE: Unable to Perform Control V(Paste) in Excel

    Posted 10-25-2021 12:44
    Hello Amlan,

    This worked perfectly. Thank you so much.


    ------------------------------
    Shakirat Jimoh
    RPA Developer
    Waje Smart solutions
    Africa/Lagos
    ------------------------------



Welcome to Community Chat!

A space for non-technical chat, tips for using the Community, and news from the Blue Prism Community Team.

This is not a Community for technical or Product related discussion. For a list of available communities, please visit our site map.

Introduce YourselfCommunity Quick TipsWomen in RPA