Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Embedding images to PowerPoint


Hi,

I tried coping pasting a table from Access Point to Power Point , I got a package convert pop up box as attached in the image.

Can somebody guide me with the right steps to paste charts from Access Point to Power Point??

Thanks in advance!!

Regards,

Pooja

1 Reply
VishalWaghole
Specialist II
Specialist II

Use this macro.

Sub ppt

'An array with the objects you want to export to powerpoint

Dim myArray(1)

myArray(0) = "LB01"

'Create ppt object

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

'Apply a template if you want one

'objPresentation.ApplyTemplate _

   ' ("C:\mytemplate.ppt")

'For each object in the array create a new slide and paste it.

For each item in myArray

Set PPSlide = objPresentation.Slides.Add(1,11)

ActiveDocument.GetSheetObject(item).CopyBitmapToClipboard

PPSlide.Shapes.Paste

Next

'Clean up

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub

then create one button,

Go to button properties -> Action -> select (Run Macro) Action -> In Text box Write Macro Name as ppt -> ok.

Note : Instead of LB01 put your object Id.

- Regards,

Vishal Waghole