I have multiple sheets/dashboards in qlikview and I can export them into PPT using the macro function with below script.
But I want to define the area to exported into PPT by defining the height and width to be cropped from the dashboard.
Attached the query for reference kindly help in further.
Thanks in advance.
| Script |
|---|
sub exportppt Set objPPT = CreateObject("PowerPoint.Application") objPPT.Visible = True Set objPresentation = objPPT.Presentations.Add objPresentation.SaveAs "D:\QlikView\ExportMF1.ppt" PPSlideNo = 1 For i = 0 to activedocument.noofsheets -1 Set PPSlide = objPresentation.Slides.Add(PPSlideNo,12) ActiveDocument.GetApplication.WaitForIdle ActiveDocument.ActiveSheet.CopyBitmapToClipboard PPSlide.Shapes.Paste Set PPSlide = Nothing Set PPPres = Nothing Set PPApp = Nothing activedocument.nexttab PPSlideNo = PPSlideNo + 1 NEXT objPresentation.Save objPresentation.Close objPresentation.Quit End Sub |
