Macros not working in Server

[#1]

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

[simospa]

Hi,

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

Current Local Security is on Allow System Access?

S.

[#3]

Yes i have all the security set to allow system access

[andrespa · Accepted solution]

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

[stigchel]

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