Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Macros failed on access point?

Hi,

I have macros for export to excel, it works good on my desktop when i allow system access, but on access point it is not working.

It shows below error.

Can anyone please help me to solve this.

Thanks

8 Replies
jerrysvensson
Partner - Specialist II
Partner - Specialist II

Does the user have Excel installed?

You have to use Plugin as client to get this to work. WebView (Ajax) doesn't work.

qlikuser222
Creator
Creator
Author

Thanks for reply,

Yes, User has excel installed, and using ie plugin

marcus_sommer

Within the modul security (left side of modul editor) you need to enable system access to create an excel-application.

- Marcus

tamilarasu
Champion
Champion

Nicholas,

Go to editor  window and select the security level that’s required: “System Access” and “Allow Access System”.

qlikuser222
Creator
Creator
Author

HI

I did that and its working good on desktop, but not on access point.

Thanks

qlikuser222
Creator
Creator
Author

HI

I did that and its working good on desktop, but not on access point.

Thanks

tamilarasu
Champion
Champion

Check below link. Make sure all the suggestions are done from your side.

ActiveX component can't create object: 'PowerPoint.Application' error on IE Plugin

jerrysvensson
Partner - Specialist II
Partner - Specialist II

When you opened the app the first time, did you get a dialog saying something about security?

If so did you check the third one (bottom)?