How to Export text file to Qlikview file location

[#1]

Hello Friends,

I want to export the file to default location where Qlikviewfile is located i have written a code as following

Sub TabDelimitedTextGroup1                                      

    set obj1 =ActiveDocument.GetSheetObject("CH20")    

    obj1.Export "D:\MYfile\E.A.T 2\Group1\"&Date()&"_"&replace(Time(),":","")&".txt",","

    MsgBox("DataHas Been Transfered")

End Sub

but it works on my machine

I want to set a default location where Qlikview file islocated no matter which machine it is used.

I hope some 1 can help me

[kaushiknsolanki · Accepted solution]

HI,

    There is a variable in qlikview which stores the path of the application i.e. QvWorkPath

    Use this variable in your macro. Something like this.

Sub TabDelimitedTextGroup1 

    Set Var = ActiveDocument.GetVariable("QvWorkPath")                                   

    set obj1 =ActiveDocument.GetSheetObject("CH20")   

    obj1.Export Var.GetContent.String&"\"&Date()&"_"&replace(Time(),":","")&".txt",","

    MsgBox("DataHas Been Transfered")

End Sub

Regards,

Kaushik Solanki

[#3]

Hi,

use obj1.ServerSideExport instead of Normal Export

[#4]

Thank you very much Koushik .