topic Re: Export two objects into one ppt slide in QlikView

Export two objects into one ppt slide

Anonymous — Thu, 14 Jan 2016 14:19:41 GMT

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.

Re: Export two objects into one ppt slide

sinanozdemir — Thu, 14 Jan 2016 16:01:04 GMT

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.

Re: Export two objects into one ppt slide

Anonymous — Thu, 14 Jan 2016 17:03:51 GMT

Thanks, dear!

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

Re: Export two objects into one ppt slide

sinanozdemir — Thu, 14 Jan 2016 17:40:56 GMT

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

Re: Export two objects into one ppt slide

Anonymous — Thu, 14 Jan 2016 18:07:30 GMT

Thanks!

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

Re: Export two objects into one ppt slide

sinanozdemir — Thu, 14 Jan 2016 18:27:09 GMT

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

Re: Export two objects into one ppt slide

Anonymous — Fri, 15 Jan 2016 14:56:52 GMT

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.

Re: Export two objects into one ppt slide

sinanozdemir — Fri, 15 Jan 2016 15:01:06 GMT

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

Re: Export two objects into one ppt slide

Anonymous — Fri, 15 Jan 2016 15:03:31 GMT

No. Create template manually and paste data by macro

Re: Export two objects into one ppt slide

sinanozdemir — Fri, 15 Jan 2016 16:11:40 GMT

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

Re: Export two objects into one ppt slide

Anonymous — Mon, 18 Jan 2016 08:25:18 GMT

Good day!

Could you please write some code for it?

Re: Export two objects into one ppt slide

sinanozdemir — Mon, 25 Jan 2016 15:08:47 GMT

Hi,

Sorry. I had a hectic schedule. I will get back to you with this.

Thansk