Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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.
Regards
Tripati
may be check this link
Hi Seetu,
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.
Regards
Tripati
Hi..Tripati,
Try below mentioned code it may works:
Sub Export_Image()
//The next 3 lines will set the user preference to enable Caption & Border while exporting//
set up = ActiveDocument.GetApplication.GetUserPreferences
up.ChartUseCapNBorder = True
ActiveDocument.GetApplication.SetUserPreferences up
//The next 2 lines will export the chart object//
set obj = ActiveDocument.GetSheetObject("CH512")
obj.ExportBitmapToFile "C:\MyLocation\Myfile.pdf"
End Sub
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.
Regard's
Sarvesh Srivastava
Hi Sarvesh,
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.
Regards
Tripati
Take a look here: https://www.google.de/search?q=vba+powerpoint+insert+picture+from+file
- Marcus