Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

VBscript macro not working with ActiveDocument

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"

0 Replies