DoCmd.transferSpreadsheet cannot delete spreadsheet cell

  • Thread starter Thread starter Alan
  • Start date Start date
A

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???
 
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
 
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?
 
i have this solve this problem now, i need to add excel object framework so
i could call the method
 
Back
Top