Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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