topic Re: Call file from macro editor in QlikView

Call file from macro editor

johngouws — Wed, 06 Jun 2018 01:18:35 GMT

Good morning.

Currently I have a script which distributes PDF's to various persons. Sample below. All this works perfectly, but I would like to have the script moved outside of the VB Script editor. The reason for this is that it will make maintenance a bit easier.

I would imagine I need to have a new SUB which calls the txt or vbs file from C:\Qlik\Distribution\Weekly.vbs. Unfortunately I cannot get this to work. Please could you give me any pointers on this.

Thank you - much appreciated.

Re: Call file from macro editor

petter — Wed, 06 Jun 2018 05:32:14 GMT

There is actually a nine year old thread that tells you how to do it:

Include external module/macro code

Look at the answer and code that Rob Wunderlich rwunderlich has provided.

Re: Call file from macro editor

petter — Wed, 06 Jun 2018 05:59:56 GMT

I couldn't help myself - had to check if the old code (from rwunderlich still worked in the latest QlikView version which is QlikView November 2017 SR5 (12.20) and it did

Re: Call file from macro editor

johngouws — Mon, 11 Jun 2018 03:31:48 GMT

Hello Petter.

Thank you very much for this solution. This is going to solve the problem for me. I thought someone would have wanted this solution at some stage. Thanks to rwunderlich‌ for publishing it.