Run export macro using Accesspoint

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I have created a Qlikview document which uses a macro to save out some variables to an excel spreadsheet.

It works fine when used in the Qlikview client, but will not work when used from AJAX over the server.

The spreadsheet which is used to save the data into is located on the Qlikview server itself and all paths are referenced correctly.

Any ideas how to get this macro to work?

Thanks

Dan

My macro code:

Sub SaveToExcelSheet

'Define file paths

Set oXL = CreateObject("Excel.Application")
Set oWB = oXL.Workbooks.Open(f_name)
Set oSH = oWB.Worksheets("Data")

'Copy the qlikview input variables into VB variables

Set VB_DATE = ActiveDocument.Variables("V_DATE")

'Discover the next empty row in the excel file

VB_NEXTEMPTYROW = oXL.WorksheetFunction.CountA(oSH.Columns("A:A"))

'Save out the variables into the empty row

oSH.Cells(VB_NEXTEMPTYROW +1 ,1).Value = VB_DATE.GetContent.String

'Save and close the excel file in the background

oWB.Save
oWB.Close
oXL.Quit

End Sub

jerrysvensson — Fri, 02 Sep 2011 11:52:21 GMT

Have you checked the box "Allow unsafe macro execution on server" ? It is in System/QlikView servers/Security

topic Run export macro using Accesspoint in QlikView