topic Re: Macros not working in Server in QlikView

Macros not working in Server

Thu, 09 Apr 2015 09:18:58 GMT

Hi All

I have multiple macros in my dashboard which dont seem to work when i publish the dashboard on the server.

My Macros consist of basic ZoomtoFit macors and move tables macros.

I also have an export to excel macro.

I have read about some plugins etc you can get to make these work but im not certain if these plugins only apply to certain macros.

Can someone give me some guidance on this. I have added examples of some of my macros below.

Zoomtofit

Sub ZoomToFit

ActiveDocument.ActiveSheet.FitZoomToWindow

'ActiveDocument.GetApplication.WaitforIdle

'ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub

Move table

Sub moveRight

positionboxR "SL04"

positionboxR "CH320"

positionboxR "SL06"

positionboxR "SL05"

positionboxR "CH321"

positionboxR "SL26"

ActiveDocument.GetApplication.WaitforIdle 300

ActiveDocument.ActiveSheet.FitZoomToWindow

End Sub

Export to Excel

sub exportToExcel4

Dim aryExport(0,3)

aryExport(0,0) = "TB09"

aryExport(0,1) = "Export"

aryExport(0,2) = "A1"

aryExport(0,3) = "data"

Dim objExcelWorkbook 'as Excel.Workbook

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

end sub

Thanks

Andrew

Re: Macros not working in Server

simospa — Thu, 09 Apr 2015 09:25:05 GMT

Hi,

in Module --> Requested Module Security is setted on System Access?

Current Local Security is on Allow System Access?

Re: Macros not working in Server

Thu, 09 Apr 2015 09:55:20 GMT

Yes i have all the security set to allow system access

Re: Macros not working in Server

andrespa — Thu, 09 Apr 2015 14:02:59 GMT

Hi Andrew,

Macros only work if you're running IE Plugin, so if your server is running on Ajax, macros won't work.

Best regards,

Andrés

Re: Macros not working in Server

stigchel — Thu, 09 Apr 2015 14:26:33 GMT

Avoid macro's, there is a limited set of commands supported in Ajax see e.g.

https://community.qlik.com/blogs/qlikviewdesignblog/2014/04/28/macros-are-bad

https://community.qlik.com/message/336101#336101