RE: Button to Export Data to Excel?

Did you bother looking at the link that I posted? It would actually be very
easy to modify that code to do what you want it to do.

Cam wrote:
Klatuu,

I don't mean to export the data to Excel, but rather a command button to
analyze the current data in form view to Excel just like the button in the
toolbar "Analyze it with Microsoft Office Excel" function.

To export data to Excel, you use the TransferSpread*** action or method.
It only accepts the names of tables and queries, so it will not accept your
[quoted text clipped - 8 lines]
command button to export the filtered records to MS Excel? I tried the button
wizard, but did not see any option to export data. Thanks

--
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
Access 2000, 2002, 2003, 2007

Message posted via http://www.accessmonster.com

.