VBscript macro not working with ActiveDocument

Sun, 27 Oct 2013 17:25:21 GMT

Hi guys,

I am facing a problem in calling VBScript macro from my script whenever that macro access any OCX interface. If i do not use OCX then it works fine.

For example...

function abc(c)

abc = c

end Function

works fine and when I call

let v = abc (12)

then the value of v is 12

but if my macro looks like

function abc(c)

abc = c

ActiveDocument.GetSheetObject("CH07").Minimize

end Function

and I call

let v = abc(c)

the the value of v is null and the sheet object CH07 is not minimized.

What am i missing here?

My Macro security level is "safe Mode" and current local security is "only safe mode"

topic VBscript macro not working with ActiveDocument in QlikView