Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro parse failed

Hi

My Macro does´t work using QV Server. I get the message

Macro parse failed. Functionality was lost

Error:Object Required ValorCeldaDimension(..)

I pass this arguments:

set myvar = ValorCeldaDimensionPivot("CH46", "Indirectos", 2, 9)

and my funcction is: (to obtain the value of a cell in a pivot table where the text of the row =texto)

Function ValorCeldaDimensionPivot(objeto, texto, dimens, col)
set obj = ActiveDocument.GetSheetObject(objeto)
dim fila
fila = 0
for RowIter = 0 to obj.GetRowCount-1
set cell = obj.GetCell(RowIter,dimens)
if cell.Text = texto then
ValorCeldaDimensionPivot = obj.GetCell(fila, col)
exit Function
End if
fila = fila + 1
next
End Function

Anybody can help me?

1 Solution

Accepted Solutions
Not applicable
Author

solved installing QV9 SR2

View solution in original post

2 Replies
Not applicable
Author

solved installing QV9 SR2

subin6600
Creator III
Creator III

I have got another work around which could help you solve the problem

1. Open your QVW file via Internet Explorer

2. Type Ctrl + Shift + M

3. Choose the option "Give System Access to Module Script" and click "OK".

untitled.JPG

BR,

Subin