topic Re: load script in vbs in QlikView

load script in vbs

brindlogcool — Sat, 22 Nov 2014 14:59:09 GMT

Can we call the Load script in the .vbs file. I am trying to export all the tables in the qvw file using the vbs script. I don't want to use the edit script or the edit module (to avoid the dependency).

Is there any way we can do it?

Re: load script in vbs

marcus_sommer — Sat, 22 Nov 2014 16:10:38 GMT

Yes, you could use an external vbs-file which contained statements to create a new qlikview instance, opened one or more qvw, does something (reload, export, print ...) and then afterwards closed the qvw and instance again.

But I would do this in a external qvw-file. Then you could better and more flexible define (as own fields) which qvw, tables, objects you want to export to which target (in a loop through these fields).

You will find many examples here to this topic with searching to http://community.qlik.com/search.jspa?q=macro+export+excel and within the APIGuide.qvw.

- Marcus

Re: load script in vbs

brindlogcool — Sat, 22 Nov 2014 16:53:21 GMT

Thanks Marcus, I was looking for the script

http://community.qlik.com/docs/DOC-4304

http://community.qlik.com/docs/DOC-7007

Only thing is all the code is run through the Edit Module. But i want to run it through the vbs script.

Re: load script in vbs

marcus_sommer — Sat, 22 Nov 2014 17:07:49 GMT

Macros inside a qvw or in an external vbs-file are nearly the same and it's rather not important. But if I look on your links it could be more easily to use native qv script-functionalities and store these tables as txt-files. These txt-files could you easily use in excel or other databases.

- Marcus

Re: load script in vbs

brindlogcool — Sat, 22 Nov 2014 17:11:16 GMT

Thanks Marcus