Macro Query

hopkinsc — Tue, 18 Sep 2012 08:52:40 GMT

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.

Re: Macro Query

hopkinsc — Tue, 18 Sep 2012 11:04:05 GMT

solved it.

I had to disable UAC in windows 7

Re: Macro Query

hopkinsc — Mon, 08 Oct 2012 11:33:05 GMT

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

topic Re: Macro Query in QlikView

Macro Query

Re: Macro Query

Re: Macro Query