Basically you export the underlying data, not the report itself. Look up DoCmd.
This is a very elegant topic. Try "Integrating Excel and Access" by Michael Schmalz from O'Reilly. (Sorry Wrox, I have most of your books already anyway.) This is a new book specifically for this topic. I am on the second chapter, but very nice so far.
HTH
mmcdonal
|