load script in vbs

[brindlogcool]

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?

[marcus_sommer]

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

[brindlogcool]

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.

[marcus_sommer]

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

[brindlogcool]

Thanks Marcus