topic Re: VB Script in Script editor in QlikView

VB Script in Script editor

Thu, 18 Feb 2016 04:59:02 GMT

Hi, Once, I was asked by a colleague that whether we can write and execute VB script in script editor window of qlikview. How we can do that if its possible. I would like to provide some background why I need this. We have a excel file that is stored at some location and we want to move it to a desired folder before qlikview scheduler begins to execute data refresh/load process. If you have an alternate solution to do this that would be grate. Thanks in advance -Priyanka

Re: VB Script in Script editor

sasikanth — Thu, 18 Feb 2016 05:03:48 GMT

HI,

Through batch file you can achieve this , before triggering QV qpplication trigger this batch file that contains code to copy excel from one location to another

Re: VB Script in Script editor

Thu, 18 Feb 2016 05:07:33 GMT

Thanks Sunny. why this method didn't came into my mind

Re: VB Script in Script editor

sasikanth — Thu, 18 Feb 2016 05:34:30 GMT

Re: VB Script in Script editor

marcus_sommer — Thu, 18 Feb 2016 06:35:41 GMT

You could also trigger this within the load itself:

Re: QVW to create bat file which contain the copy command for all the QVD's used in the QVW. Help on this!

Is it possible to create a batch file in the Qlikview Script

- Marcus