Macro to export text from a text box to External Script in Qlikview

sahilkain — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am looking for a Macro which can extract some keyword from a text/table box/straight table and send it to a predefined string as a BAT file. It would be highly appreciated if anyone can help me here.

Regards,

Sahil

Re: Macro to export text from a text box to External Script in Qlikview

marcus_sommer — Fri, 11 May 2018 14:03:42 GMT

If it's not depending on any user interactions it might be easier to create it within the script, maybe with something similar to this: Re: Is it possible to create a batch file in the Qlikview Script.

If this isn't possible a table-chart or a listbox would be easier to handle for it because they could exported as a text-file (a textbox only to excel). And there should just the needed output be contained so that it's not necessary to extract anything on the macro-side (the Qlik string-functions are quite powerful). And then you could use something like this:

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.txt", 1

If you really want to use a textbox than you need to write these data, maybe with something like this: Re: Export to CSV with quotation marks (it's for table but by a textbox it's quite the same).

As far as you go with any macro-approach the APIGuide.qvw (within your install folders by automation) will be very useful for you.

- Marcus

topic Re: Macro to export text from a text box to External Script in Qlikview in QlikView

Macro to export text from a text box to External Script in Qlikview

Re: Macro to export text from a text box to External Script in Qlikview