topic Export Active Sheet object into PPT in QlikView

Export Active Sheet object into PPT

soha1902 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can any one help me, to write a macro to export Active sheet all Objects into PPT.

I went through several examples on community but all were exporting all sheet objects into PPT. I want to export only active sheet all objects into PPT.

Thanks in advance.

Re: Export Active Sheet object into PPT

Anil_Babu_Samineni — Thu, 09 Jun 2016 10:15:48 GMT

Soha,

I dont know about PPT. But i created one macro for data transfer active sheets to PDF / Excel...

If you are fine, So that i can share with you..

Re: Export Active Sheet object into PPT

Digvijay_Singh — Thu, 09 Jun 2016 10:19:38 GMT

Check this out -

Trying to export charts from active sheet to ppt

Re: Export Active Sheet object into PPT

bindu_apte — Thu, 09 Jun 2016 10:20:43 GMT

Hi,

Please find the attached qvw that will help you.

Re: Export Active Sheet object into PPT

Anil_Babu_Samineni — Thu, 09 Jun 2016 10:26:14 GMT

Perfect.

Re: Export Active Sheet object into PPT

bindu_apte — Thu, 09 Jun 2016 10:33:29 GMT

Hi Anil,

If this solution is helpful then please mark as correct answer.

Re: Export Active Sheet object into PPT

Anil_Babu_Samineni — Thu, 09 Jun 2016 10:37:51 GMT

Bindu,

I don;t have permissions to put the mark.

Might be, Whoever created the discussion them only do that. And i just want to check let's assume i have some dash board. I want to ask you one thing if i want to export whole data like which ever is the active sheet. i want to show that all active sheet objects / Graphs into the PPT.

How?