topic Re: How to Run VBscript file from Qlik Sense in Integration, Extension & APIs

How to Run VBscript file from Qlik Sense

Anonymous — Mon, 10 Apr 2017 06:23:56 GMT

Hi All,

I would like to know how to run / call VBscript file placed on desktop location from Qlik Sense App . Please provide some information to do this

Thanks

R Dhana

Re: How to Run VBscript file from Qlik Sense

rupalimane1390 — Fri, 02 Jul 2021 13:31:46 GMT

Hey @Anonymous , did you find the solution to this in qliksense ?? I need to do exact same to automate excel and create various worksheets within with the help of vbscript.

Re: How to Run VBscript file from Qlik Sense

Clever_Anjos — Fri, 02 Jul 2021 14:01:53 GMT

Hi, I think you should reconsider this and try to use another approach. What does your VBScript do?

Re: How to Run VBscript file from Qlik Sense

rupalimane1390 — Fri, 02 Jul 2021 14:05:55 GMT

Hello @Clever_Anjos ,

I am using VBscript to autocreate an excel and copy paste qlik objects in various sheets(Tables, charts,pivots etc.)- This approach works in qlikview and I worked on it in the past.

I really do not know any other approach for autogenerating excel workbook.

Re: How to Run VBscript file from Qlik Sense

Clever_Anjos — Fri, 02 Jul 2021 14:09:10 GMT

As Qlik Sense uses another approach (100% web technologies that don´t rely on client) you will need a language like python, c#, node.js, etc and connect to the platform API (https://help.qlik.com/en-US/sense-developer/May2021/Content/Sense_Helpsites/Build-create-explore.htm) to achieve what you need.