Hello:

I need a VB Code to copy the data from current file, Sheet "Summary" Range B5:E30 to closed workbook at path :C:\Temp\2014-File.xls\ Sheet "Employees at location T2.
Basically i do not want to manually open the destination file and do and paste.

Please let me know if you have any questions.
Thanks.


Riz