Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to send each sheet of dashboard to different slide of ppt
You might reply to this post and ask for his macro:
Set PPApp = CreateObject("Powerpoint.Application")
PPApp.Visible = True ' Create a presentation
Set PPPres = PPApp.Presentations.Add
Set PPSlide = PPPres.Slides.Add(1, 1)
ActiveDocument.GetSheetObject("CH15").CopyBitmapToClipboard
PPSlide.Shapes.Paste
PPPres.SaveAs "E:\Qlikview\Prima\PPT\Presentation.ppt"
PPPres.Close
PPApp.Quit
Set PPSlide = Nothing
Set PPPres = Nothing
Set PPApp = Nothing