topic Re: How to export qlikview sheet to power point in QlikView

How to export qlikview sheet to power point

Wed, 27 Apr 2016 10:08:12 GMT

Hi All

Please tell me, Is it possible to export one sheet in a qvw file to power point..

Thanks

Ganesh

Re: How to export qlikview sheet to power point

vikasmahajan — Wed, 27 Apr 2016 10:10:41 GMT

see this https://community.qlik.com/thread/212111

vikas

Re: How to export qlikview sheet to power point

kkkumar82 — Wed, 27 Apr 2016 10:12:42 GMT

Other than macros you can use tools like Nprinting

Re: How to export qlikview sheet to power point

Wed, 27 Apr 2016 10:17:49 GMT

Actually, Do we need license to use N-Printing?? I have licensed Desktop client ,

Is NPrinting is again a different Application or can we use it in Personal Edition?

Thanks

Ganesh

Re: How to export qlikview sheet to power point

Wed, 27 Apr 2016 10:19:59 GMT

with this, can we export entire sheet or some of the objects in sheet?

actulally, i have no knowledge of Macros, I am unable to understand anything in the link you provided

Thanks

Re: How to export qlikview sheet to power point

vikasmahajan — Wed, 27 Apr 2016 10:23:30 GMT

check with this QlikView NPrinting 16 Tutorials by Subject

Re: How to export qlikview sheet to power point

Anonymous — Wed, 27 Apr 2016 10:44:38 GMT

check the following the link

Prepare PPT from different QVW objects with Macro

Re: How to export qlikview sheet to power point

kkkumar82 — Wed, 27 Apr 2016 11:00:38 GMT

Nprinting is a seperate license, to use nprinting client you have to request Qlik for trial licenses and remember to work with the different options of Nprinting we require a licensed Qlikview Desktop.

Its all about licenses

Re: How to export qlikview sheet to power point

Wed, 27 Apr 2016 11:02:31 GMT

Yeah, than i wont go for N-Printing, I dont think we buy N-Printing License in near future

Thanks

Ganesh

Re: How to export qlikview sheet to power point

Anonymous — Wed, 27 Apr 2016 12:51:06 GMT

by using the code and change the objectids than

at macros

Sub ExportPPT

ActiveDocument.ActiveSheet.FitZoomToWindow

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

Set PPSlide = objPresentation.Slides.Add(1,11)

' ActiveDocument.ActiveSheet.CopyBitmapToClipboard

ActiveDocument.GetSheetObject("CH19").CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = objPresentation.Slides.Add(1,11)

' ActiveDocument.ActiveSheet.CopyBitmapToClipboard

ActiveDocument.GetSheetObject("CH14").CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = objPresentation.Slides.Add(1,11)

' ActiveDocument.ActiveSheet.CopyBitmapToClipboard

ActiveDocument.GetSheetObject("LB20").CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = objPresentation.Slides.Add(1,11)

' ActiveDocument.ActiveSheet.CopyBitmapToClipboard

ActiveDocument.GetSheetObject("LB17").CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = Nothing

Set PPPres = Nothing

End sub

and give the request module is system access a

and current local security is allow system access

and create the button and go to the action and select the external and select the macro and give the name what available at the macro code and run the code and get the output

Re: How to export qlikview sheet to power point

Wed, 27 Apr 2016 12:53:30 GMT

Oh god thank you bro.. Really amazing, I will try this now

Thank you very much

Re: How to export qlikview sheet to power point

Wed, 27 Apr 2016 16:07:54 GMT

Hi Sudhakar

I created a button and gave the macro name as ExportPPT

First I tried to export one sheet so i edit your code and kept my sheet name

when i click on button, PPT is opening with blank slide..

could you please see and tell me where i am going wrong,, dont mind if even I am unable to edit the code properly..

Sub ExportPPT

ActiveDocument.ActiveSheet.FitZoomToWindow

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

Set PPSlide = objPresentation.Slides.Add(1,2)

ActiveDocument.ActiveSheet.CopyBitmapToClipboard

ActiveDocument.GetSheetObject("SH02").CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = Nothing

Set PPPres = Nothing

End sub

Thanks

Ganesh

Re: How to export qlikview sheet to power point

Anonymous — Thu, 28 Apr 2016 05:24:32 GMT

YOU NOT REMOVE THE OBJECT AT ActiveDocument.GetSheet NOW TRY THIS CODE THAN TOY GET THE OUTPUT

Sub ExportPPT

ActiveDocument.ActiveSheet.FitZoomToWindow

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

Set PPSlide = objPresentation.Slides.Add(1,11)

' ActiveDocument.ActiveSheet.CopyBitmapToClipboard

ActiveDocument.GetSheet("SH02").CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = Nothing

Set PPPres = Nothing

End sub

Re: How to export qlikview sheet to power point

Thu, 28 Apr 2016 09:24:34 GMT

Hi sudhakar

Still, the blank slide is opening, dont know where i am going wrong..

Re: How to export qlikview sheet to power point

Anonymous — Thu, 28 Apr 2016 10:18:20 GMT

That code is working in my application

Re: How to export qlikview sheet to power point

Anonymous — Thu, 28 Apr 2016 10:19:40 GMT

in button you given the action tab to give the external and run macro and give the name of the macro name is exportppt

Re: How to export qlikview sheet to power point

Thu, 28 Apr 2016 10:29:54 GMT

Hi Sudhakar

Yeah , exactly.. Please see the below screenshot

Thanks

Re: How to export qlikview sheet to power point

Anonymous — Thu, 28 Apr 2016 11:18:54 GMT

Re: How to export qlikview sheet to power point

Anonymous — Thu, 28 Apr 2016 11:19:23 GMT

are you got the output right now

Re: How to export qlikview sheet to power point

Thu, 28 Apr 2016 11:25:00 GMT

No i am not getting output, still blank slide is opening