Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
in chart properties > caption>check the box export to xl
no I need to automate this
i know I can right-click and export to excel ; come on!!
Hi,
Check if this helps.
Regards
ASHFAQ
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?