topic Re: Execute .vbs file in Load Script in QlikView

Execute .vbs file in Load Script

Wed, 31 Dec 2014 17:47:23 GMT

Is it possible to execute VB Script through Script editor.

I want to create a VB Script to send a mail by taking input as MailID from a field.

For that i should execute VB script from Script editor. How to Call a vbscript?

Call C:\...\SendMail.vbs ?

execute C:\...\SendMail.vbs ?

anybody did work on?

Re: Execute .vbs file in Load Script

Wed, 31 Dec 2014 18:12:17 GMT

Can't you just include it using the Include statement and then refer to its functions or subs ?

Re: Execute .vbs file in Load Script

Wed, 31 Dec 2014 18:16:42 GMT

$(Include=.\lib\yourfile.qvs);

I believe the extension doesn't matter but let's see the opinion of others in the forum.

qvs stands for qlikview script but it contains vbscript subs and functions

Re: Execute .vbs file in Load Script

rwunderlich — Wed, 31 Dec 2014 18:44:46 GMT

You can execute VBScript from within the script execution in one of two ways.

1. Use the script EXECUTE statement.

EXECUTE cscript c:\dir\sendmail.vbs parms

not sure I got the syntax exactly right, you'll have to experiment.

2. Functions that are included in the qvw module (Ctrl-m) can be called as script functions from within the script. For example, if you coded a function named sendmail that took a single parameter in the module.

LET x = sendmail(toaddr);

LOAD sendmail(toaddr) as X, ...;

For an example of creating and calling a script function, see:

Qlikview Cookbook: Regular Expression Pattern Matching http://qlikviewcookbook.com/recipes/download-info/regular-expression-pattern-matching/

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Execute .vbs file in Load Script

Wed, 31 Dec 2014 19:05:31 GMT

Hi Rob,

But if He only wants to send an Email chances are he just need to put the code internally in the edit module area right? unless he will need to attach or do extra work at the OS level.

2015 MASTERS SUMMIT Wow!

Re: Execute .vbs file in Load Script

rwunderlich — Wed, 31 Dec 2014 19:15:37 GMT

Hi Mario,

For sending mail I think EXECUTE may be easier. It can be a lot less code because you can use a command line program like blat or sendmail and just pass parameters.

Also, the macro module cannot get System Access when run as a server reload. Usually to send mail in the module you have to do something like CreateObject() which requires System Access.

-Rob

Re: Execute .vbs file in Load Script

Fri, 02 Jan 2015 14:39:20 GMT

Thank you Mario and Rob for sending me the snippets.

One of them did work to execute the VBScript. It is

EXECUTE wscript c:\dir\sendmail.vbs parms

I just changed the cScript to wScript.

Re: Execute .vbs file in Load Script

adcgermany — Mon, 11 Nov 2019 06:50:02 GMT

Hi ,

Could you please paste the load script for just executing one vbscript ..no parameters to pass.

Regards,

Gibin