View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chet Shannon[_4_] Chet Shannon[_4_] is offline
external usenet poster
 
Posts: 20
Default Copy method of worksheet class failed - help!

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 Befo=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