copy sheet and paste into sheet in closed file

Good afternoon,

Was wondering if someone could help me out with a piece of code.

What i need to do is when closing the workbook i would like to copy the sheet called "registos",

and paste it on the sheet "registos" in the closed workbook ... \\server\server\Dest1.xls...



i used this piece of code to get data from the closed file in open book event and works fine ... but cant send to the closed file on close book event if i use same logic....i get out of range error...

Please Login or Register  to view this content.

thanks

This is the basic idea:

Please Login or Register  to view this content.

Out of range error can occur for many reasons. Since I don't have your files, I can only guess, but my guess is the destination file is missing or the "Registos" page is not there, so cannot be deleted. If you get errors, you should really specify which line through the error; makes it much easier to troubleshoot.

@oeldere,

Was unaware of the cross-post. You posted your message while I was in the process of writing mine. I generally assume a poster has followed the forum rules unless I see evidence to the contrary.

sorry for that i posted on both so i could get a quicker answer... i wasnt aware that i couldnt

gyclone thank you that helped m8

You're welcome! Aside from the issues mentioned above, cross-posting clogs search results with multiple hits on the same question, which is very frustrating to anyone searching on the same issue. Pick the forum and forum site you think will get you the best results. Post once, post clearly, and wait for the experts there to help you. If your need is so immediate that you can't wait a day or two for an answer, consider hiring a consultant who has the necessary expertise.