topic Re: Macro to export more than one Sheet objects into PPT in QlikView

Macro to export more than one Sheet objects into PPT

Mon, 15 Sep 2014 03:03:28 GMT

Hi,

I am trying some scenarios in Qv objects export to PPT i have encountered some problems

I can succesfully export QV objects to PPT if i have single sheet.

now my series of issues appears where i cant able to Export to PPT

1) If i have buttons(with variables used to hide the charts)

2) if i have more than one sheet

Can any one suggest me how to export the objects to PPT from more than one sheet and the buttons which have the hide variables to show the chart

Here is the Sample App

Re: Macro to export more than one Sheet objects into PPT

Mon, 15 Sep 2014 03:50:18 GMT

Suggestions required

Re: Macro to export more than one Sheet objects into PPT

ecolomer — Mon, 15 Sep 2014 03:50:40 GMT

Your file modified.

Re: Macro to export more than one Sheet objects into PPT

Mon, 15 Sep 2014 03:58:49 GMT

Thanks Enrique for your response

but unfortunately i couldnot get the required solution from your sample

i am getting the following errror in the macros

"Shapes.Paste : Invalid request. Clipboard is empty or contains data which may not be pasted here." and no object is shown in PPT

Re: Macro to export more than one Sheet objects into PPT

Mon, 15 Sep 2014 04:02:45 GMT

I could only see the following info in the PPT no sheet objects

i am attaching the screen shot of the PPT which i have got

do let me your suggestions !

Re: Macro to export more than one Sheet objects into PPT

Mon, 15 Sep 2014 04:29:02 GMT

Suggestion required

Re: Macro to export more than one Sheet objects into PPT

ecolomer — Mon, 15 Sep 2014 05:11:31 GMT

See the image

Re: Re: Macro to export more than one Sheet objects into PPT

ecolomer — Mon, 15 Sep 2014 05:13:47 GMT

Reload

Re: Macro to export more than one Sheet objects into PPT

Mon, 15 Sep 2014 05:34:19 GMT

Thnaks

even in the app that u shared

we could able to see the objects from sheet Main sheet only not in the sheet1

kindly go through it

Re: Re: Macro to export more than one Sheet objects into PPT

ashfaq_haseeb — Mon, 15 Sep 2014 06:53:16 GMT

Hi,

Check if this helps.

Regards

ASHFAQ

Re: Macro to export more than one Sheet objects into PPT

Mon, 15 Sep 2014 07:11:07 GMT

Hi Ashfaq

thanks for the reply but that doesnot work accurately

still we are nt getting the object from second sheet

Re: Macro to export more than one Sheet objects into PPT

Mon, 15 Sep 2014 07:59:33 GMT

required help

Re: Re: Macro to export more than one Sheet objects into PPT

marcus_sommer — Mon, 15 Sep 2014 11:19:35 GMT

Have a look on this app - for each chart from active qv-sheet will be one new slide created. You will have to adapt these logic to your needs. Generally most important if you handles with many objects, sheets and/or conditions is:

activate sheet --> activate object --> object conditions --> (partly) restore --> copy

goto excel/ppt/ ...

activate sheet --> select target-range --> paste

It is a step for step task - useful will be: Google. The adaption to vbscript is then rather easy.

- Marcus

Re: Re: Re: Macro to export more than one Sheet objects into PPT

Mon, 15 Sep 2014 17:14:15 GMT

Hi Marcus,

Thanks for responding me .

my requirement is when i have more than one sheet object to be exported into PPT.

i was succesfuly exported one sheet objects into PPT but the main problem comes with more than one sheet

and also i need an export button upon clicking on it should be exported i have created this one my problem lies with more than one sheet .

I couldnot identify the logic .

I am attaching the application

Re: Re: Re: Re: Macro to export more than one Sheet objects into PPT

Anonymous — Mon, 15 Sep 2014 19:19:32 GMT

Hi,

please see attached.

the routine will cycle through all charts for each sheet in the application and extract (1:1) to ppt slide.

Re: Macro to export more than one Sheet objects into PPT

Tue, 16 Sep 2014 03:39:14 GMT

Hi Autopilot,

Double thanks for your reply and i need a small correction cant we do all the sheet objects in one slide and the other sheet objects in the other slide?

really thanks for your solution u keep my day alve.

Re: Re: Macro to export more than one Sheet objects into PPT

Anonymous — Tue, 16 Sep 2014 14:18:16 GMT

no problem....glad to help.

see attached.

Re: Macro to export more than one Sheet objects into PPT

Wed, 17 Sep 2014 03:27:17 GMT

Hi,

Thanks again for your valuable solution.

we have reached almost 90% but a small alignment problem and sheet order problem

we are getting the first sheet in the last slide and vice versa. The objects are placed at centre and other still objects cant be visible though they are exists in the slides.

Hope i can get solution for this aswell

Re: Macro to export more than one Sheet objects into PPT

Wed, 17 Sep 2014 03:42:01 GMT

Suggestion required

Re: Re: Macro to export more than one Sheet objects into PPT

Anonymous — Wed, 17 Sep 2014 15:50:10 GMT

see attached.

updated order of output and object spacing on slides.