Out put is Text File

[Former Member]

Hi ,

In my Requirement I want output is Text Format.

I have a Work Book, after executing this work book i want to that all data saved in a Text File.

Thanks

Priya

[Former Member · Accepted solution]

From Execl, File - Save as - chouse text file an proced.

Hope it helps.

Regards

[Former Member · Accepted solution]

Hi Paolo,

Is it any other other way so that we can get directly Text Format.

Thanks

Priya

[Former Member · Accepted solution]

You can create a macro that do that and put it in

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

Code here

End Sub

to run automatically at every refresh.

Here you can find some detail:

/people/sap.user72/blog/2006/06/05/long-texts-in-sap-bw-displaying-in-bex-analyzer-introduction-to-excel-workbooks-formatting-part-ii

Regards

[Former Member · Accepted solution]

Thanks Raj & Paolo

Priya

[Former Member]

The foll. link has some details:

Thanks,

Raj