Adapt Code to copy and paste multiple Ws to multiples Ws to another Wb

Hi.

i try use code in:http://www.rondebruin.nl/win/s3/win024.htm

But i need use in multiples sheets (from -> OrgFile) to multiples sheets (to -> DestFile)

How adapt this code to copy (OrgTab1, OrgTab2, OrgTab3) from OrgFile to (DesTab1, DesTab2, DesTab3) DestFile

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Why not instead of

Please Login or Register  to view this content.

just a simple loop, like:

Please Login or Register  to view this content.

Hi Kaper, tahnk you!

But how do it based my real file?
Tip Name
Origin file ContrAva_ES.xlsx
Tab Origin file Alex
Tab Origin file Glaucia
Tab Origin file Patricia
Tab Origin file Escher
Tip Name
Destination file John_Controle de Avarias_PAN ES.xlsm
Tab Destination file Alex
Tab Destination file Glaucia
Tab Destination file Patricia
Tab Destination file Escher

Hi any idea?

thank you!!

for instance if names in source and destination are always the same:

Please Login or Register  to view this content.

or if destination names are different than origin

Please Login or Register  to view this content.

hi.
Display error message

compilation error
Incompatible type of argument ByRef

Thank you!!

check again names - especially OrgFile.xlsx vs ContrAva_ES.xlsx

I try, but still display error
look my picture

Looks fine for me. but it's always better to experiment (or investigate) with a file not just a screenshot. of course not real files but smaller dummy files where problem persists.

Look at my files, please.

thank you!!!

Do explicit type conversion to string in:

Please Login or Register  to view this content.

Hi karper, nice.

very very good!

Thank very much!