Hi there,

Does anyone know why I get the following error when exporting data from my
VB app to Excel 2007 ONLY WHEN the default save file format in Excel 2007 is
set to "Excel 97-2003 workbook (*.xls)"?

"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...of anmother workbook. (Code: 1004)"

No error is obtained using the same process when the default save file as is
the default 2007 "xlsx" or "Excel 5.0/95 Workbook (*.xls)"...
--
thanks in advance.
smacd...