DoCmd.transferSpreadsheet cannot delete spreadsheet cell

This is my code

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"temp_MonthlySalesReport",
"F:\Accounts\Projects\Analysis\Billlings\DSICMM\Ac cess\MonthlySalesReport",
True
Call
ModifyExportedExcelFileFormats("F:\Accounts\Projec ts\Analysis\Billlings\DSICMM\Access\MonthlySalesRe port", "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/...UBED1=ACCESS-L


"Alan" wrote in message
...

This is my code

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

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

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" wrote:

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/...UBED1=ACCESS-L


"Alan" wrote in message
...

This is my code

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

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


.

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
ToolsReferences 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/...UBED1=ACCESS-L


"Alan" wrote in message
...


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" wrote:

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/...UBED1=ACCESS-L


"Alan" wrote in message
...

This is my code

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

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


.

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

"Roger Carlson" wrote:

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/...UBED1=ACCESS-L


"Alan" wrote in message
...

This is my code

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

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


.