Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
tripatirao
Contributor II

Macro to export Image into ppt

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

5 Replies

Re: Macro to export Image into ppt

tripatirao
Contributor II

Re: Macro to export Image into ppt

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
Contributor III

Re: Macro to export Image into ppt

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
Contributor II

Re: Macro to export Image into ppt

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

MVP & Luminary
MVP & Luminary

Re: Macro to export Image into ppt