Discussion board where members can get started with QlikView.
Does anyone knows if it is possible to export text object content to a text file.
Thanks in Advance.
Right click your sheet object -->click on properties -> export and save as .txt file
check this simple macro, it will create a txt file at same path with qvw
Set obj = ActiveDocument.GetSheetObject("TX01")
Set objpro = obj.GetProperties
Set docpro = ActiveDocument.GetProperties
Set fso = CreateObject("Scripting.FileSystemObject")
Set f1 = fso.CreateTextFile(docpro.MyWorkingDirectory & "\TX01.txt", True)
also find my example attached
Hi , before you run the macro , plz ensure you have allowed system access for it
Ctrl + M to open and set
txt file will be saved at same path with qvw file