Macro parse failed

Mon, 26 Jan 2026 18:19:17 GMT

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?

Macro parse failed

Fri, 15 Jan 2010 13:47:07 GMT

solved installing QV9 SR2

Macro parse failed

subin6600 — Thu, 03 May 2012 07:29:55 GMT

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".

BR,

Subin

topic Macro parse failed in QlikView

Macro parse failed

Macro parse failed

Macro parse failed