Solved Excel VBO Pasting error

Status
Not open for further replies.

cs.andras

Active Member
Staff member
Hi Everyone,
I'm a little puzzled what to try next. I need to paste external data (previously copied by BluePrism to the clipboard) into a fresh Excel sheet.
I have the sheet open, handle and all... I have saved it too prior to pasting (I've read this on Stackoverflow where they also suggested to someone else to use direct data-setter code, but this isn't VBA). Is there a way to send a keystroke to an Excel BO which is created during runtime?
This is the error I get btw, it is a VB error, bubbling up into BP: Failed to paste from clipboard: PasteSpecial method of Range class failed.
Thanks in advance for any help.
Andras
 

cs.andras

Active Member
Staff member
Hi Andras,

Instead of pasting the clipboard into Excel, could you use the GetClipboard() function to save the clipboard into a data item/collection and then use the Excel VBO to set cell value?

Rob
I'll give that a try, thanks!
 
Status
Not open for further replies.
Top