Worksheet copying in Excel 2007
On Jan 14, 1:46*pm, jeh wrote:
For years I've use a simple macro to copy sets of fixed format text
files into a related excel workbook, one workbook per set of input
files (up to ~60) and one new worksheet per input file. *The input
files are about 400 rows x 20 columns. *No problem in excel 2000.
However in Excel 2007 the same macro crashes, at the copy sheet line,
with the error message *"Excel cannot insert the sheet into the
destination workbook because it contains fewer rows and columns that
the source workbook".
Has anyone got an explanation and/or a workaround for this in E2007?
Reverting to Excel 2000 isn't a long-term option.
TIA
John
It would help to see the code.
Doug
|