Hi all,
i have a question concerning the export function with macro. I want to ask for 2 functionalities.
1. Export of images of ALL sheets to ppt in defined format
I found and tried macros which can copy an image of active sheet in powerpoint. How can i copy images of all sheets in an qv file in one powerpoint file? Is it possible to define the size of images which are copied into powerpoint (e.g. 200x120 or 1200x800)?
2. Export of defined Pivot Tables in one excel sheet
I found and tried macros which can copy one pivot table in an excel document. Thats fine. But is it possible to copy more than one defined pivot table (CH01, CH05, CH14) into one excel file (several sheets)? If that is possible, can i define the name of the sheets?
It would be great if you can help me! Thanx in advance
Jezze
