topic Passing String to Macro in QlikView

Passing String to Macro

Thu, 26 Feb 2015 02:58:09 GMT

Hi all,

I'm trying to execute a macro from load script. But I need to pass a string to the macro function. But for some reason, the string is not passed. Here is an example:-

Macro:

function createFile(a)

set fso = CreateObject("Scripting.FileSystemObject")

set s = fso.CreateTextFile("D:\test.txt", True)

s.writeline(a) //it is not wring anything to the file

s.Close()

end function

In the load script:-

LET vTest = createFile("testing script");

Any idea on what is wrong in the script above?

Thanks.

Re: Passing String to Macro

rwunderlich — Thu, 26 Feb 2015 05:58:57 GMT

There should be single, not double quotes, around your string.

LET vTest = createFile('testing script');

Also make sure your Module security is set to "Allow System Access".

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Passing String to Macro

Mon, 02 Mar 2015 09:33:19 GMT

Thanks! It works now. I remember that I tested it with single quote, but it didn't work. So I tried the double quote... weird!