Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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