topic Re: Macro to export Image into ppt in QlikView

Macro to export Image into ppt

tripatirao — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Macro to export Image into ppt

settu_periasamy — Tue, 21 Feb 2017 15:19:13 GMT

may be check this link

Export multiple objects to a single powerpoint slide

Re: Macro to export Image into ppt

tripatirao — Wed, 22 Feb 2017 09:51:54 GMT

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

Re: Macro to export Image into ppt

sarvesh — Wed, 22 Feb 2017 10:03:48 GMT

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

Re: Macro to export Image into ppt

tripatirao — Wed, 22 Feb 2017 13:22:14 GMT

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

Re: Macro to export Image into ppt

marcus_sommer — Wed, 22 Feb 2017 14:55:45 GMT

Take a look here: https://www.google.de/search?q=vba+powerpoint+insert+picture+from+file

- Marcus