Skip to main content
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
Not applicable
Author

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

Not applicable
Author

No not trigger is used.

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

is used.

vardhancse
Specialist III
Specialist III

Hi

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

Not applicable
Author

Hi,

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

But its working fine on QV Desktop.

vardhancse
Specialist III
Specialist III

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

Can you paste the macro code.

Not applicable
Author

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

jerrysvensson
Partner - Specialist II
Partner - Specialist II

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

bertdijks
Partner - Contributor III
Partner - Contributor III

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

2014-04-22 13_55_14-QlikView Management Console.png

Not applicable
Author

Yes Jerry Svensson we have