Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macros not working in Server

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

1 Solution

Accepted Solutions
andrespa
Specialist
Specialist

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

View solution in original post

4 Replies
simospa
Partner - Specialist
Partner - Specialist

Hi,

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

Current Local Security is on Allow System Access?

S.

Not applicable
Author

Yes i have all the security set to allow system access

andrespa
Specialist
Specialist

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
Partner - Master
Partner - Master