C
CLR
Hi All.....
I have a program that opens a second file and then copies a sheet out of it
into the main program. It was written in XL2000 and works fine. When I try
to run it in XL2007 it stops on the following line:
ActiveSheet.Copy after:=ThiisWorkbook.sheets(1)
And gives the following error message:
"Excel cannot insert the sheets into the destination workbook, because it
contains fewer rows and columns than the source workbook. To move or copy
the data to the destination workbook, you can select the data, and then use
the Copy and paste commands to insert it into the sheets of another workbook."
The sheet I'm trying to copy is only 450 rows and about 15 columns, and
copies fine in XL2000.
Any ideas would be appreciated.
Vaya con Dios,
Chuck CABGx3
I have a program that opens a second file and then copies a sheet out of it
into the main program. It was written in XL2000 and works fine. When I try
to run it in XL2007 it stops on the following line:
ActiveSheet.Copy after:=ThiisWorkbook.sheets(1)
And gives the following error message:
"Excel cannot insert the sheets into the destination workbook, because it
contains fewer rows and columns than the source workbook. To move or copy
the data to the destination workbook, you can select the data, and then use
the Copy and paste commands to insert it into the sheets of another workbook."
The sheet I'm trying to copy is only 450 rows and about 15 columns, and
copies fine in XL2000.
Any ideas would be appreciated.
Vaya con Dios,
Chuck CABGx3