Macro to export Image into ppt - Qlik Community

tripatirao · ‎2017-02-21

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

settu_periasamy · ‎2017-02-21

may be check this link

tripatirao · ‎2017-02-22

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

sarvesh · ‎2017-02-22

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

tripatirao · ‎2017-02-22

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

marcus_sommer · ‎2017-02-22

- Marcus