pastespecial method of range class failed

[Rekragisao]

Hello People,

I'm trying to get the data that i input into one workbook to be pasted into a database in another workbook.

So far I've pretty much gotten what i want except for one crucial part which is pasting the copied data into the new workbook. Below is the code that I've been constructing, what it does is copy a selection from the open workbook's second sheet and then opens the right sheet in the workbook i want it copied to and selects the right range to where it should be copied.

The issue i'm facing is then when i try to paste the values using .PasteSpecial i get the error message "pastespecial method of range class failed", However I can't seem to find out what I've done wrong to cause this error.

If anyone has any suggestions it would be greatly appreciated.

With regards,

Rekragisao

End with

Please Login or Register  to view this content.

[xlnitwit]

Hi,

I imagine that opening the other workbook has cleared the clipboard. Why are you using two separate routines to perform this task? Further, what is the Wait and Sendkeys part required for?

[Rekragisao]

Hey,

the sendkeys is just to shift the selection back from column B to A so that the data is pasted in the right colomn since A has no values in it. the wait command i added because else the sendkeys command wouldn't go trough for some reason.

I initially used 2 seperate routines because when trying to do it in one i kept running into errors. I'll give a shot at merging the 2 into one to see if that will fix the pasting issue.

Thanks for the imput

[xlnitwit]

Perhaps this

Please Login or Register  to view this content.

[Rekragisao]

This works like a charm

Thanks you very much!