Export from Access damages my Excel-Workbook
 

Hi Guys (and girls of course)

I run following code in Access2003 (I now, this is an excel-forum, but
I think the problem is in Excel):
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "PLAN",
FileName, True

FileName is the name of a Workbook, that i copy prior to this line. I
tested the copy procedure of the sheet separately to see if this could
be the problem, it's not.

When the code ran, i open my workbook and i get the following
statement: File Error, Data may have been lost.
And the Exported Worksheet is all scrambled, also another worksheet,
that was there before the export is damaged.

If I put a blank worksheet into FileName, it works perfect.

Anyone knows, why that happens, and/or how I can get around that?
Do I have to move the worksheet, after exporting? would be
troublesome.

Thanks for your help, it's highly appreciated

Carlo