Export to Excel

S

SC

Can someone tell me how to write the vb code to export a datasheet to excel
without first saving the file. I just want it to open excel and insert the
data without first being prompted to save the excel file.

Thanks
 
K

Ken Snell \(MVP\)

Have you tried using TransferSpreadsheet to do this? Much easier than
writing more complex code to write data directly into EXCEL sheet's cells.
 
K

Ken Snell \(MVP\)

Try TransferSpreadsheet. It creates and saves the new EXCEL file without
asking you to do it.
 
D

Douglas J Steele

In addition to the fine advice Ken's given you, you might want to take a
look at my June 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access", where I talk about using Automation from Access to interact
with Excel.

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html
 
Top