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
