Call file from macro editor

[johngouws]

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.

[petter]

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.

[petter · Accepted solution]

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

[johngouws]

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.