Macros are not working in accesspoint(IIS)

[#1]

Hi,

i have a qvw file, it's working fine in the QlikView Personal Edition.

but if i place the same file in the QlikView Server (AccessPoint), it is not working properly.

Functionality of the macro is copying chart data and create a excel with this data in specified path location in same machine.

the Macro is not working properly. what could be the issue?

so what we have to do this?

Thanks,

Sahithya

[#2]

Hi Magdalena,

I set secutiry properties as "System Access" .Please see screeshot below:

I opened through IE plugin.

My macro is copying the chart properties and save it into excel and connecting to R and converting excel o/p to JPG image and reloading the script.

Its copying the chart properties when I tried to open in IE plugin but its connecting connecting to R.

[#3]

reloading the script will not work through access point. you can only reload the script directly in QlikView.

regards,

MT

[#4]

Any other way to reload the script

[#5]

Not in access point that I know of.

regards,

MT

[#6]

Hi,

I am trying to copy the chart properties into excel. I wrote macro as below:

Sub Test

XlsPath = "c:\lab\patient.xls"
'Create excel File
MsgBox("1")
Set objExcel = CreateObject("Excel.Application")
MsgBox("HiNew")

Set objWorkbook = objExcel.Workbooks.Add()

Set objWorksheet = objWorkbook.Worksheets(1)

'ActiveDocument.GetSheetObject( "CH148" ).CopyTableToClipboard true

set table = ActiveDocument.GetSheetObject( "CH148" )

'DIm array(7,2)
For RowIter = 0 to table.GetRowCount-1
For ColIter = 0 to table.GetColumnCount-1
set cell = table.GetCell(RowIter,ColIter)
'array(RowIter,ColIter)=cell.Text
objWorksheet.Cells(RowIter+1,ColIter+1).Value=cell.Text
'Msgbox(cell.Text)
Next
Next

objWorkbook.Saveas XlsPath
MsgBox("2")
objWorkbook.close
objExcel.quit

In macro editor, security properties are "System Access" for Requested Module Security and "Allow System Access" for Current Local Security.

I opened the dashbaord in IE plugin in accesspoint. In accesspoint, its showing issue as below:

.