Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Please tell me, Is it possible to export one sheet in a qvw file to power point..
Thanks
Ganesh
see this https://community.qlik.com/thread/212111
vikas
Other than macros you can use tools like Nprinting
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
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
check with this QlikView NPrinting 16 Tutorials by Subject
check the following the link
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
Yeah, than i wont go for N-Printing, I dont think we buy N-Printing License in near future
Thanks
Ganesh
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