Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Macro Query

Hi All,

My client has a macro that they have been running for the last 6months without any problems. Now they are looking to upgrade their user machines to windows 7 so they are running a few tests to check compatibility.

They have encountered a problem where the macro no longer works. I have done some testing also and found the same result (doesnt work on Windows 7).

The macro is to print the dashboard ...

SUB PrintDashboard

       SET val=ActiveDocument.Fields("%KEY%").GETPOSSIBLEVALUES(100)
       FOR i = 0 to val.count-1            
          ActiveDocument.Fields("%KEY%").SELECT val.item(i).Text
'         ActiveDocument.ActiveSheet.print 
          ActiveDocument.ActiveSheet.Dialogprint
       NEXT

END SUB

Allow unsafe macro's and allow macro execution are both 'Ticked' on the server.

They are accessing through the IEPlugin, although i have also tested AJAX which didn't work either.

They are running QV Server v 11

The macro works if i open the QVW directly from the Qlikview client or Open in Server.

2 Replies
hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

solved it.

I had to disable UAC in windows 7

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi everyone,

I solved the above issue by turning off the UAC in windows 7, but my client has got back to me today saying that even though the above resolution works, their IT department will not allow the UAC to be changed.

Does anyone have a work around for this?

Many thanks

Chris