topic How to set Easter Egg (ExcelExportMixedAsText) options by Load Script or VBScript in QlikView

How to set Easter Egg (ExcelExportMixedAsText) options by Load Script or VBScript

Thu, 08 Jan 2015 12:12:14 GMT

Hi!

I would like to know if it is possible to set Easter Egg, specially ExcelExportMixedAsText by Load Script or by Visual Basic Script.

Here is the tasks that I have done:

I have checked the article, QlikView Core COM API Guide - Version 11 | Qlik Community and I haven't found any method o properties that let us to set Easter Egg.
I have written down in the load script the line Set ExcelExportMixedAsText = 0; and it doesn't work.

So, does anybody any idea?

Is it the only way to set the Easter Egg options by modifying settings.ini file?

Any Help we will appreciate

Thanks in advance

Cheers,

Francisco Perez

Re: How to set Easter Egg (ExcelExportMixedAsText) options by Load Script or VBScript

marcus_sommer — Thu, 08 Jan 2015 12:25:38 GMT

I don't think that there is a way to set these settings with macros. Access to the easter egg:

Menu --> Help --> About QlikView --> right click on qlik-symbol in bottom left corner

But be careful with changes.

- Marcus

Re: How to set Easter Egg (ExcelExportMixedAsText) options by Load Script or VBScript

Thu, 08 Jan 2015 12:40:42 GMT

Thanks Marcus,

I agree, I think there is no way to automate this features. So I am afraid I have to write down to a little document to guide user and IT guys to deploy the Qlikview clients and IE Plugins.

Cheers,

Francisco Perez