paste to another work book in next row

[shaunsheep2345]

Please can someone look at my code.
It seems to be doing all the write things but doesn't paste.
The code Adds a load of data to a sheet, then copy's this data , opens a new workbook and should past in the next row down offset by 1,1.
But nothing pastes in ?
Code attached.

The code adds the data to the sheet fine -checked
It also selects the correct line to copy -
It opens the workbook-finds the correct sheet -highlights the correct row. But then nothing. Saves and closes

Thanks

[Logit]

.
I temporarily edited the code so it could be tested here (since your workbooks are not available for testing here).
This is what I was working with :

Please Login or Register  to view this content.

Commenting out some of the code allowed me to test the "copy and paste" aspects of the code. It works fine here.

Perhaps you need to focus on the ", WriteResPassword:="QualityClinic"" command.

I did not do any testing on it here, but it would appear that is the only thing left to confirm. Is the password correct ?
Does it need a password prior to pasting ? Have you utilized the correct syntax for providing the password ?

See attache workbooks.

[shaunsheep2345]

Took the password off, still no difference.

The sheet is not protected either.

.
I temporarily edited the code so it could be tested here (since your workbooks are not available for testing here).
This is what I was working with :

Please Login or Register  to view this content.

Commenting out some of the code allowed me to test the "copy and paste" aspects of the code. It works fine here.

Perhaps you need to focus on the ", WriteResPassword:="QualityClinic"" command.

I did not do any testing on it here, but it would appear that is the only thing left to confirm. Is the password correct ?
Does it need a password prior to pasting ? Have you utilized the correct syntax for providing the password ?

See attache workbooks.

[Logit]

.
Sent you a private message. Still waiting on your workbooks.

[Logit]

.
Here is the working macro. You will need to edit the path to match your project.

I chose not to use as many variables (replacements for object names) so you could easily see what was being referenced.

Please Login or Register  to view this content.

In addition there were a few commands in the UserForm_Initialize event that I eliminated.

Please Login or Register  to view this content.

Also, I changed the location of the combobox list. You may need to edit that as well.