Export to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Have you tried using TransferSpreadsheet to do this? Much easier than
writing more complex code to write data directly into EXCEL sheet's cells.
 
Try TransferSpreadsheet. It creates and saves the new EXCEL file without
asking you to do it.
 
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
 
Back
Top