Exporting Expressions as a tab file or excel file using macro

[rajpreeths]

Hi Guys,

Is there any macro available with you to export all the expressions into a single file like we export the variables into excel file???

Currently I am doing this export manually as below

Setting --> Expression Overview-->Export-> Save File

But I have to do the same thing for 400 reports. So it would be helpful if you guys share me the macro available for doing achieving this export.

Thank you in advance!

Rajpreeth S

[bindu_apte]

Hi,

Hope this thread will be helpful.

Macro to export Script

[rajpreeths]

Hi Bindu,

I would like to have EXPRESSIONS export into a excel or tab or csv file format not script export.

[marcus_sommer]

I don't think that the expression overview is available/acessable per macro and to try to loop through all sheets/objects and their expression-properties would be require enormous efforts. Therefore I think the easiest way would be to export the layout-file and reading it again into qlikview (and than maybe storing or exporting them):

ActiveDocument.ExportLayoutFile "c:\AppLayout.xml"

- Marcus