Need Help In Qlikview Macro

[tripatirao]

Hi Experts

I am able to export charts into ppt for selecting each value in listbox but my requirement is i want more than one charts in single slide.

I have attached sample  qlikview file along with macro and ppt which i am getting when running the macro.

I have also attached  PPT which i want as output.

Please help me. I am trying to get this from past few days but i am not able to get the output.

Regards

Tripati

[tripatirao]

Dear Experts,

Any Help............

Regards

Tripati

[hector_munoz]

Hi Tripati,

Look at this sentences:

  powerpoint.ActiveWindow.Selection.ShapeRange.Left = pos_x

  powerpoint.ActiveWindow.Selection.ShapeRange.Top  = pos_y

With this sentences you can locate last object pasted exactly where you need.

Maybe you also need to resize the objects, smaller, in order they fit to the slide.

I attach you a sample of PPT export (in spanish)...

Long live to macros!!!

Regards,
H

[tripatirao]

Hi,

I have tried with your code

But not getting the desired output,

I have the attached the qlikview file and ppt for your reference.

Regards

Tripati

[sasiparupudi1]

Please look at the option of using a container.

Macro that combines two sheet objects and export as a single image.

[tripatirao]

Hi Sasidhar,

i have only one chart in my application and Same charts is exporting into ppt by looping through the value of listbox.

If 2 charts are there then I can use your code.

Please check the macro in the attached QV file and suggest me where i have to change the code.

Regards

Tripati

[hector_munoz · Accepted solution]

Look at what I attach... I think is what you need... Regards !

[sasiparupudi1]

Hi Tripati,

Please have a look at my post.. I hope this is what you are expecting. If you are happy with the solution, please do not forget to close the thread by marking a correct and any helpful answers

Loop through a dimension and export a chart into power point

Good Luck

Sas

[tripatirao]

Dear Sasidhar,

Thanks for time on this issue.I have gone through  your document.Really nice one.

Really Appreciate your work.

As It was urgent I adopted  Hector code and I have implemented on my original application.

It worked fine.