MACRO tO Copy Ranges from 2 Closed Workbooks

[Floydlevedale]

Hi

I need Macro that can copy ranges from 2 workbooks that are 'closed'. Their Address on PC D:\EXCEL FORUM\Book1.xlsx & D:\EXCEL FORUM\Book2.xlsx
Range ( B1:B12 ) for Book2 and (a1:a18) for Book 1. Macro to run from DESTINATION WORKBOOK attached.

[Kaper]

You can use such code (I used a function originaly published on our national forum: https://www.excelforum.pl/viewtopic.php?t=12354 ):

Please Login or Register  to view this content.

[jindon]

Simply

Please Login or Register  to view this content.

[Floydlevedale]

Thanks Jindon, Just Excellent