Export two objects into one ppt slide

[Anonymous]

Good day!

In my model i have macro which export object ch02 ch03 into two slides.

how to change macro code to export these objects into one same slide?

Thanks.

[sinanozdemir · Accepted solution]

Hi,

Let me know if this is what you are looking for:

All I did was to comment out the line of vbscript code that added more slides:

I am also attaching the qvw.

Hope this helps.

Other useful links by Sinan:

Handling Metadata in QlikView

QlikView and Python Integration

QlikView Automation Series – Unzip & Load Excel Files:

[Anonymous]

Thanks, dear!

Maby you also know how do add text in slides? To format this text, set text colour and font?

[sinanozdemir]

No problem.

I am quite familiar with PPT library, what to use for text boxes or not.

So let me poke around little bit, I will get back to you.

Thanks

[Anonymous]

Thanks!

I have one question: macro export objects withous captions. Is there any way to export objects with captions?

[sinanozdemir]

Sure:

Just go to Settings -> User Preferences -> Export tab and then make sure that Chart is checked and if you want to apply this other objects, just check them as well:

Thanks

[Anonymous]

Dear, thanks!

Tell me please, can macro export data in some ppt template ? (not create new clear presentation)

if yes, could you please write vba example for it?

Thanks.

[sinanozdemir]

Do you mean like creating a template via a macro and export the data onto it again via a macro?

[Anonymous]

No. Create template manually and paste data by macro

[sinanozdemir]

Let me try to put something together. Although, it would be very simple.