export to excel

[ali_hijazi]

Hello

got 3 pivot tables

I want to export these into one excel workbook and each on a sheet in the excel

is there a macro that does this?

please advise

[Anonymous]

in chart properties > caption>check the box export to xl

[ali_hijazi]

no I need to automate this

i know I can right-click and export to excel ; come on!!

[ashfaq_haseeb]

Hi,

Check if this helps.

Regards

ASHFAQ

[ali_hijazi]

ok that's fine but I need to have always one excel file

will the SaveAs method simply overwrites existing excel file on every time the macro is ran?