exporting objects from sheet to excel with the button by using macro

[#1]

hi

i have created a report and now i want to create a button 'export to excel' and this button must export the objects of the active sheet to the excel...how cani achieve that ???

explain it with a simple example???

[#2]

Try searching for export to excel macro in the forum.

It would be nice if you first checked if your question has already been asked.