Discussion Board for collaboration on QlikView Scripting.
Hello to everybody,
I would like to export all of my objects from all my sheets into ppt, but I didn't get it.
Looking into this community, I found a macro and I copied and pasted into my qv, but this macro only export one object.
Do you know how to export all of the objects from all of the sheets into ppt?.
This is the macro that only export one of the objetcs.
pos = activedocument.evaluate("=getactivesheetid()")
set v = activedocument.Getvariable("vShowAll")
Set PPApp = CreateObject("Powerpoint.Application")
PPApp.Visible = True
Set PPPres = PPApp.Presentations.Add
for j = 0 to ActiveDocument.NoOfSheets - 1
Set PPSlide = PPPres.Slides.Add(1, 1)
for i=lbound(charts) to ubound(charts)
' Set PPSlide = PPPres.Slides.Add(1, 1)
' PPSlide.Shapes(1).Delete ' removes the title
' PPSlide.Shapes(1).Delete ' removes the text box
Set PPSlide = Nothing
Set PPPres = Nothing
Set PPApp = Nothing
msgbox "PPT Extract Successful",64,"Complete"
Thanks a lot.
Suggestions required please.
Have a look here: Automated PowerPoint Presentation Extraction
Hello Marcus, I looked that, but this doesn't work in my qv .
I have got show all my objects in a slide of ppt but someone knows if is possible to show all the objects like a screenshot?.
Thanks in advance.