VBA help, starter needed for export to txt 1

[riddlermarc]

Hi,

n00b to Tek-Tips so apologies if I step on anybody's toes etc

I'm wanting to write a macro for a Busines Object report that will save each of the included tabs to a specified place, with the filename of {tab_name}.txt.

eg.

Three tabs called HQ, Southern, Great Western.
I want to save the first one as \\server\location\HQ.txt, then the second as \\server\location\Southern.txt and so on.. anyone able to help, please? I have spent the last 20mins Googling for BO/VBA help but nothing is forthcoming - can anyone also give me pointers as to where I can learn, please? I am a web developer by trade, just having to run a few BO reports for some functionality.

Kind regards,
Marc McAllister

 

[Sridharan]

Marc,

Here is the code

Sub ExportTxt()
    For i = 1 To ActiveDocument.Reports.Count
        ActiveDocument.Reports.Item(i).ExportAsText ("\\server\location\" & ActiveDocument.Reports.Item(i).Name)
    Next
End Sub

Good Luck
Sri