topic Macro to append script in QlikView

Macro to append script

Tue, 13 Sep 2011 15:38:42 GMT

Hello QV Experts,

Below macro in (first.qvw) will read a text file and writes it to another (recon.qvw) file. The text file contains SQL select statements. I am facing a issue with below code.

1. When I run the macro it just opens the recon.qvw file, but the script is not getting added. Please help.

Thanks in advance

sub UpdateScriptFromfile

set FSO= createobject("Scripting.FilesystemObject")
set openReconFile=FSO.OpenTextFile("C:\Qlikview\buildsql.txt")
scriptBackup=openReconFile.ReadAll
openReconFile.Close
msgbox(scriptBackup)
set newdoc = GetObject("C:\Qlikview\recon.qvw")
newdoc.GetProperties.Script = scriptBackup

end sub

Macro to append script

kaushiknsolanki — Wed, 14 Sep 2011 05:25:20 GMT

Hi,

Try this.

sub UpdateScriptFromfile

end sub

Regards,

Kaushik Solanki

Macro to append script

Wed, 14 Sep 2011 05:33:22 GMT

Thank you so much Kaushik

It worked with your change.