Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro not working on access point

Hi All,

I have to export QV report to ppt using macro it is working fine with QV desktop

but it is not working in web mode (access point).

I do have IE plugin installed.

Is there any way I can do it on access point, or any alternative tool/plugin?

Thanks in Advance.

11 Replies
jerrysvensson
Partner - Specialist II
Partner - Specialist II

I am not sure, but I think unsafe macro checkbox only applies to Ajax macros.

jerrysvensson
Partner - Specialist II
Partner - Specialist II

Add two msgboxes. If you only see the first one, there is a problem with creating the powerpoint object.

sub exportppt

Msgbox "Before CreateObject"

Set objPPT = CreateObject("PowerPoint.Application")

Msgbox "After CreateObject"

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

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

ActiveDocument.ActiveSheet.CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub