topic Re: Macro code is not working for inserting images into PPT in QlikView

Macro code is not working for inserting images into PPT

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

Hi all,

I have some image in the PNG format in a specific folder. I wants to export those images into ppt by using below macro code.

Sub main()

Dim objPresentaion As Presentation

Dim objSlide As Slide

Dim objImageBox As Shape

Set objPresentaion = ActivePresentation

Set objSlide = objPresentaion.Slides.Item(2)

Set objImageBox = objSlide.Shapes.AddPicture("E:\Qllikview\ExcelTask\*.png", msoCTrue, msoCTrue, 100, 100)

End Sub

But it is not working for me.

Please check and do the needful.

Regards

Tripati

Re: Macro code is not working for inserting images into PPT

marcus_sommer — Mon, 27 Feb 2017 12:01:50 GMT

I'm not sure but I don't believe that you could add images with a wildcard else you will need some kind of a loop and you will also need some further logic where to place and to size them. But this isn't really related to qlikview and I think you will find suitable stuff rather in office-communities or within here: https://www.google.de/search?q=vba+ppt+addpicture

- Marcus

Re: Macro code is not working for inserting images into PPT

beck_bakytbek — Mon, 27 Feb 2017 16:14:42 GMT

Hi Rajana,

check this: Automated PowerPoint Presentation Extraction

and this : Export QV objects to ppt template

i hope that helps

beck