I have a workbook name Updates. It has a command button that has the following code attached to it.
Private Sub CommandButton1_Click()

    Workbooks.Open Filename:="C:\Documents and Settings\Administrator\Desktop\Sizzler\Inventory\WalkRoutes.xlsx"
    Workbooks("walkroutes.xlsx").Activate
    Sheets("WalkRoute").Activate
    Range("A1:G205").Select
    Range("A1:G205").Copy
There's more code but my problem lies in this part of the code.
What I am trying to do is copy the range A1 to G 205 in the workbook named "Walkroutes".
then paste it into the workbook named "Updates"

When I try to run the code it fails with a Runtime Error 1004 Select Method of Range Class Failed.

Can someone help me with the code to make it copy the cells in the workbook "Walkroutes" and paste them into the workbook "Updates" ?

Thank you for reading this and any help you can offer.