TransferSpreadsheet

[Pietro]

Hi,

I'm trying to export a query to MS Excel 2007,I don't know what should i
select in the Spreadsheettype item in the VB code, i tried to select 8 but i
lost the Chart I have in one of the Excel tabs...
Please advise,knowing that My database is formatted 2000,I'm using MS
Office 2007.

DoCmd.TransferSpreadsheet acExport, 8, "daily report",
"O:\Pietro\Pietro\Customer Support\Source\Reports\Tier1.xls"

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportToExcel2k.mdb" which illustrates one way to do this.

--
--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