Export to Excel

[brindlogcool]

Hi

Is it possible to export two objects in to one Excel sheet. Consider i have pivot table and text box. i want to export the pivot table data to excel and at the end of excelsheet i would like to have the text box data. ?

Can this be done through macros ?

If yes how to take care of the issue if the pivot table data exceeds the first sheet then the text box data should be moved to second sheet of Excel.

[#2]

did you try to create a report, and to add the pivot and the two objects into it, and after that to export it. I never tested this function, but saw it in a presentation that it is possible to have multiple objects added to a report, so you can export them all togather.