EXCEL/VBA copy multiple cell from other workbook into 1 workbook

Closed
hlfoong Posts 1 Registration date Thursday July 23, 2015 Status Member Last seen July 23, 2015 - Jul 23, 2015 at 02:34 AM
Hello,

I would like to copy couple of cell from multiple workbook into 1 workbook using Marco/VB.

Example:
Source
C:\temp\A.xls. Cell needed AB59
C:\temp\B.xls. Cell needed C36
C:\temp\C.xls. Cell needed A45

All to active workbook.
AB59 = A23
C36 = A25
A45 = A27

Please assist/help me. Thanks in advanced.