Help with copy text from one workbook to another.

[jcranst]

Here is what I came up with using the macro recorder. The Report Template.xlsm is the sheet containing the macro.

'Open File
    ChDir _
        "N:\Projects\_General Office\Invoices\Invoice Files"
    Workbooks.Open Filename:= _
        "N:\Projects\_General Office\Invoices\Invoice Files.xlsx" _
        , UpdateLinks:=0
    'Copy 
    Windows("Template for Vlookups.xlsx").Activate
    Range("B1:C3").Select
    Selection.Copy
    Windows("Report Template.xlsm").Activate
    ActiveSheet.Paste

It opens the sheet and then just stops. Any Tips?