All you need is:

Workbooks("2006-01-OAKAM-MOP.xls") _
.Worksheets("OAKAM Facility Diagram").Copy _
Before:=Workbooks("2006-02-OAKAM-MOP.xls") _
.Worksheets("AM Flight Schedule")

--
Regards,
Tom Ogilvy

"Chet Shannon" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> Am getting an error that says 'copy method of worksheet class failed". My
> code is
> Windows("2006-01-OAKAM-MOP.xls").Activate
> Worksheets("OAKAM Facility Diagram").Activate
> Sheets("OAKAM Facility Diagram").Copy Before:=Workbooks( _
> "2006-02-OAKAM-MOP.xls").Worksheets("AM Flight Schedule")
>
> Is there a workaround or am I doing something wrong? I am just copying a
> worksheet from workbook A to workbook B.
>
> Thanks,
> Chet
> --
> Chet Shannon