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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gustavgager
Partner - Creator II
Partner - Creator II

Load a Qlikview OCX object instead of QV desktop?

Hi there.

I currently have a customer who wants a script that does a few selections in a cople of diffrent fields, and then export this to excel. I dont want to use a macro inside the qvw so im trying get this to work form an external source.

Using a Autoit script i have been able to create a COM object for QV desktop and do all tyhe selctions and export to excel, no problem. But for a couple of other diffrent reasons, i dont want to install QV desktop on his computer. So i would like to do this using a siilar procedure, but using the IEPlugin (OCX) instead of QV desktop.

When i use QV desktop i use this to create the COM object:

$Qview = ObjCreate("QlikTech.QlikView")

So how can i do a similar thing, but isng the Plugin instead? Since the polugin is installed, the approprietade files should be enabled therefor it should would. Anyone have any idees or perhaps could give me some simple VBS code that could get me started? Thanks.

0 Replies