VB Code to copy without opening the file

Hello:

Please refer to attached 2 excel files, one named as "Source" and other called "Destination".

I need VB Code in "Destination" file to perform following:

Without opening the Source file, I would like to copy cell B2:D12 from "Source" file to "Destination" file @ column letter shown in cell D1.

I have manually copied as shown in "Destination" file.

Please have a look and let me know if any questions.

Thank you

Riz Momin

Hello:

I will be copying data from lots of different files and hence i do not want to open.
Just to let you all know that i am already using this feature with the below code successfully to paste at the fixed location at Cell "E5".
I need to modify the code so that the column # reference is picked up from cell D1 of the active sheet.
Please open the 2 excel file uploaded at the BEGINNING of this thread.

Example: if Cell D1 = L, then "E5" needs to be replaced with L5.

    Set SrcRng = xlw1.Sheets("Sheet1").Range("B8:B87")
    ColsCnt = SrcRng.Columns.Count
    RowsCnt = SrcRng.Rows.Count
    ActiveSheet.Range("E5").Resize(RowsCnt, ColsCnt) = SrcRng.Value

Basically I want to modify the last line in above code where "E" needs to be variable and value can come from String called colpaste1.


I hope this clear and would appreciate for any help.
Thank you