Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

load script in vbs

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?

4 Replies
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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

Thanks Marcus