Export to Excel

[Guest]

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

 

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

 

[Guest]

No, I've been trying to use the Outputto function

 

[Ken Snell \(MVP\)]

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

 

[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