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: 
sagarkharpude
Creator III
Creator III

Unable to increase the Width of object while exporting object to ppt

Hi,

I am using the macro to export the object to ppt. But i am not able to increase the width of the object in macro. I am using the below code for top, width, height, etc.

ActiveDocument.GetSheetObject("TX150").CopyBitmapToClipboard ' Issue Description

with PPSlide.Shapes.PasteSpecial(3)

PPSlide.Shapes(PPSlide.Shapes.Count).Left = 10

PPSlide.Shapes(PPSlide.Shapes.Count).Top = 430

PPSlide.Shapes(PPSlide.Shapes.Count).width = 3

PPSlide.Shapes(PPSlide.Shapes.Count).height = 29

end with

Can someone please help me?

Thanks

10 Replies
marcus_sommer

Try it with adjusting some of the properties like in the other example from Tamil (LockAspectRatio). Whereby I'm not sure if it will be working for your wanted sizes. I think you will get nearer to your aim if you looked for vba examples/foren - maybe something like this: https://msdn.microsoft.com/de-de/library/office/ff744382.aspx (maybe at first within vba and if it's worked you could transfer the method to the qlik-vbs again).

- Marcus