controlling the loop

[Anonymous]

Hi,

I am new to VB Scripting in the edit Module and need you help.

I need the loop for the export ppt to be controlled. I could able to export the sheets to  PPT but unfortunately same sheets are repeating.

Suggest me how to control the loop

[d_pranskus]

Hi

Your problem is that you loop through all your sheets and then you export the objects from all sheets in each iteration.

You need to export just the objects from the sheet of current loop iteration.

Cheers

[Anonymous]

Thanks Darius for response

I am trying to do the same thing but unfortunately I cannot achieve the result

I need the selected sheet objects from all the sheets to be exported

can you share me the sample app

would be grateful

[d_pranskus]

Please see attached

Also on the last sheet there is a search object which for some reason is not copied to clipboard properly, that's why the statistic box is copied twice. This seems to be qv bug at least in the version I have.

[Anonymous]

Thanks for the sharp solution

but still some suggestions required there are 3 sheets but in PPT we are getting 7 slides and also I need not to get the PPT button to be exported

The same sheets objects to be placed in one Slide in the PPT (3Sheets to the 3 slides )

Kindly suggest on the same.

Hoping response from you

[d_pranskus]

Hi

Could this be of some help? http://community.qlik.com/docs/DOC-3774

[Anonymous]

This may resolve your issue or help to point you in the right direction.

see attached.

[Anonymous]

Thanks autopilot

for your immense help.

you solved my problem almost but a minor correction could you let me know the positions of the object in  a proper way. as they are coincided one on other

I am a beginner in VB , so that I could not able to figure out where the changes are to be made.

My  user needs the objects position to be as same as in the QV dashboard
Hoping a positive feedback from your end.

[Anonymous]

Thanks autopilot for your immense help.

you solved my problem almost but a minor correction needed .

I am sharing an exact requirement app in that I need the entire Main sheet , and in Sheet 1 and sheet 2 the pivot table and table boxes only to be exported to PPT

could you let me know how to set the positions of the object in  a proper way .

I am a beginner in VB , so that I could not able to figure out where the changes are to be made.

My  user needs the objects position to be as same as in the QV dashboard
Hoping a positive feedback from your end. (Share me the sample please)

[Anonymous]

To adjust the shapes position in powerpoint, focus on lines 29 - 35 in the macro script.

iterno = 1

for each shape in PPSlide.Shapes

with shape

.top = 1 * iterno

.left = 1

end with

iterno =  iterno * 270