cancel
Showing results for 
Search instead for 
Did you mean: 

Paste into a new Workbook

h_rojas_del_cas
Level 3
Hi everyone. I've been trying to paste data previously copied from a DB Management tool (Ctrl+C) to a newly created Workbook, but with the MS Excel VBO action "Paste" i've been getting an error: PasteSpecial method of Range class failed. If I just press Ctrl+V the information is pasted correctly, so the problem isn't in the way I'm copying data. ¿What can I do to correct this error? Thanks in advance.
3 REPLIES 3

John__Carter
Staff
Staff
Hi Horacio - it could be a timing issue. When it runs via BP, is there enough time between the copy and the paste? I'm wondering if the paste is happening too early, before the data is on the clipboard?

h_rojas_del_cas
Level 3
Thanks for your response John. I don't think that's the issue since I copy the data from a DB tool, then launch a new Excel workbook (with the proper wait) and try to paste the info to the newly created workbook.

John__Carter
Staff
Staff
Hmm OK then I'm guessing you should contact your Mentor for advice. Sorry I can't help further but I'm not sure what the issue is.