Export to excel

[cpamxn]

In a mcaro, i export query to excel. It asks me to save thefile, and to
overwrite and the file, etc >> standard MS pop ups. I need to export to a new
work book to avoid the the pop boxes. Thanks

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportToExcel.mdb" which illustrates how to do this. You can
find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=350

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