topic Re: Re: Macro not working on access point in QlikView

Macro not working on access point

Tue, 22 Apr 2014 10:47:28 GMT

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.

Re: Macro not working on access point

Tue, 22 Apr 2014 10:50:04 GMT

Have you set the macro as a trigger, and if so, which?

Re: Macro not working on access point

Tue, 22 Apr 2014 10:54:33 GMT

No not trigger is used.

On button--> Actions--. External --> Run Macro

is used.

Re: Macro not working on access point

vardhancse — Tue, 22 Apr 2014 11:05:31 GMT

Macro will be worked only in the IE plug in mode but not in AJAX Mode.

Can you try to change the mode from ajax and try to run the macro.

Ajax->IE Plug in mode:

Favorites & Profile ->Profile<tab>->Preferred Client Internet Explorer Plugin

Re: Macro not working on access point

Tue, 22 Apr 2014 11:08:59 GMT

Hi,

On Access point its not working on both IE plugin mode and normal mode.

But its working fine on QV Desktop.

Re: Macro not working on access point

vardhancse — Tue, 22 Apr 2014 11:12:30 GMT

I tried to run some macros in IE plugin mode. it was working fine.

Can you paste the macro code.

Re: Macro not working on access point

Tue, 22 Apr 2014 11:31:51 GMT

Hi Sasi Vardhan K,

'We are using following macro :

sub exportppt

Set objPPT = CreateObject("PowerPoint.Application")

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

'This macro is working fine in QV desktop but not on Access point (with and without IE plugin)

'Thanks,

'Prakash

Re: Macro not working on access point

jerrysvensson — Tue, 22 Apr 2014 11:47:17 GMT

Have you set the Requested Module security to System Access and Current local Security to Allow system Access ?

Re: Re: Macro not working on access point

bertdijks — Tue, 22 Apr 2014 11:59:57 GMT

You also need to be sure that the setting on the server (in Management Console) allow macro execution:

Re: Macro not working on access point

Tue, 22 Apr 2014 12:00:45 GMT

Yes Jerry Svensson we have

Re: Macro not working on access point

jerrysvensson — Tue, 22 Apr 2014 12:52:02 GMT

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

Re: Macro not working on access point

jerrysvensson — Tue, 22 Apr 2014 12:54:13 GMT

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