Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to export graphics into a powerpoint document from a Qlikview application (*.qvw). My different graphics are on different sheet, and include in some container. I don't arrive to selected the graphics inside a container (using ActiveDocument.GetSheetObject("CHxxx").Activate command). It's work correctly if graphics are outside the container.
I don't arrive to create a link to those graphic too, using Copy/Paste Sheet Object as Link Qlik function.
Did you have some information about this feature ?
Best regards.
Jean
Dear Beck,
It's seems working for a table, not for graphic. I've the following code :
Set ContainerObj = ActiveDocument.GetSheetObject("CT01") 'Container ID
Set ContProp=ContainerObj.GetProperties
SheetObj=Array("CH184","CH79","CH80","CH85") 'Chart ID's
for i=0 to UBound(SheetObj)
Set PPSlide = objPresentation.Slides.Add(2,11)
Set obj = ActiveDocument.GetSheetObject(SheetObj(i))
obj.CopyTableToClipboard True
'obj.CopyBitmapToClipboard True
PPSlide.Shapes.Paste
PPSlide.Shapes(PPSlide.Shapes.Count).Top = 150 'This sets the top location of the image
PPSlide.Shapes(PPSlide.Shapes.Count).Left = 15 'This sets the left location
PPSlide.Shapes(PPSlide.Shapes.Count).Width = 240
PPSlide.Shapes(PPSlide.Shapes.Count).Height = 250
Next
It seems working with obj.CopyTableToClipboard True, but it doesn't work with obj.CopyBitmapToClipboard True
Did you have an idea ?
Best regards.
Jean