Discussion board where members can get started with QlikView.
By using macro i am able save qlikview pivot table as image in a specific folder.
Now i want is these image to be exported into PPT by using another macro.
I have attached the images which i want to be exported into PPT.
Help me with macro code for this.
may be check this link
Export multiple objects to a single powerpoint slide
The link which you have attached in that we have macro code for exporting charts into PPT.
My Requirement is export images from a specific folder into PPT BY USING QLIKVIEW MACRO.
Try below mentioned code it may works:
//The next 3 lines will set the user preference to enable Caption & Border while exporting//
set up = ActiveDocument.GetApplication.GetUserPreferences
up.ChartUseCapNBorder = True
//The next 2 lines will export the chart object//
set obj = ActiveDocument.GetSheetObject("CH512")
Please remember to mark this as "helpful" & "correct answer" if your query has been solved.
This will help users identify the answers should they come across this thread in the future.
Thanks for your Reply.
The code given by you working for exporting chart as image but my requirement is to send the image from a particular folder to ppt by qlikview macro.
do let me know any clarification you want from my side.
Take a look here: https://www.google.de/search?q=vba+powerpoint+insert+picture+from+file