Hello,

I have a working code that replaces sheets from the source to the destination abut requires the destination file to be open. Can anybody please help me by suggesting a way to do the same when the destination workbook is closed?
Below is the code I got.

Please Login or Register  to view this content.