copy sheet and paste into sheet in closed file

[chichaspowa]

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

[oeldere]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.mrexcel.com/forum/excel-q...-workbook.html

[gyclone]

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]

@glycone,

according to the forumrules, you are not allowed to respond on a threat that has been crossposted, without notification.

[gyclone]

@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.

[oeldere]

I just try to point you on the forumrules, so you don't get an penalty of posting.

[chichaspowa]

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

[chichaspowa]

gyclone thank you that helped m8

[gyclone]

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.