G
Guest
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
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