DoCmd.transferSpreadsheet cannot delete spreadsheet cell

[Alan]

This is my code

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"temp_MonthlySalesReport",
"F:\Accounts\Projects\Analysis\Billlings\DSICMM\Access\MonthlySalesReport",
True
Call
ModifyExportedExcelFileFormats("F:\Accounts\Projects\Analysis\Billlings\DSICMM\Access\MonthlySalesReport", "temp_MonthlySalesReport1")
End Sub

Is there a way around that well let me iuse the same sheet over again???

 

[Roger Carlson]

What I generally do is save an empty workbook as a template, and then create
and save a new workbook based on the template. That way, I have a nice
clean workbook to export to. I've got a sample of that on my website called
ExportToExcel.mdb (http://www.rogersaccesslibrary.com/forum/topic350.html)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Alan]

Thanks Roger

i have tried what you have used beofre but i get a error saying USER TYPE NO
DEFINED

Dim objXLBook As Excel.Workbook

can you help?

 

[Roger Carlson]

When you declare an Excel object variable like that, you have to add a
Reference to Excel in your References list. In the VBA editor, go to
Tools>References and scroll down the list for Microsoft Excel X.0 Object
Library.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Alan]

i have this solve this problem now, i need to add excel object framework so
i could call the method