Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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