Various pasting issues

Hello everyone.

I need some help on some pasting issues I have in code (Excel 2007).

So a user open an excel spreadhseet and a userform pops open. The form has two textboxes and two buttons. In the first textbox a a date (shorthand) is entered. The user presses a button and a file with that date extension is retrieved. Upon opening the file the user is prompted to select an area to copy.

Please Login or Register  to view this content.

Now the user goes back to the userform and enters some text in a TextBox. After that she presses a button which creates and opens a new Excel file and is supposed to paste CPSelection.

Please Login or Register  to view this content.

I get two errors on various runs. One informs me that I have a paste method fail. The other informs me that I do not have enough room on the clipboard.

Any ideas?

Hi,

Look at the examples on http://www.ozgrid.com/forum/showthread.php?p=111223

You Copy to the clipboard and then go to somewhere else and need to select a cell.
You need to do a

Please Login or Register  to view this content.

and then do the

Please Login or Register  to view this content.

What is your CPSelection Dimed as? Is it a range of cells? Are you sure?

Why copying ?
Why 2 commandbuttons ?
Why writing to the same drive where the OS resides ?

Please Login or Register  to view this content.

Please remove Option Explicit; you won't need it.
I adapted the code in post #9.