Export query result to Excel fails each week

[Guest]

Hi,
I have a crosstab query that run allright, but exporting result fails each
week as new column is added. I have excel template and finalising the report
happens in Excel.
I use this command to export:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Not Confirmed
orders", wkbName

It gives me error: 3190 Too many fields defined.

Only way I am able to resolve this proble is that each week I open the
template file and delete the sheet that i am exporting. Do the modifications
and then report is OK for the current week.
How would I be able to use this template al the time without each week
updating the excel-template itself.

I am using 2003 versions.
Thanks in advance.
MakeLei

 

[Guest]

Hi,
I was able to do it in a way that I included a lot more columns to a report
and run it to excel and took that as an template and now it works all right
even when new weeks are added.

Solution that might help some others as well.
BR
Markku