Tabs - How to export each as separate file

[ainkca]

Hi all,

Any idea how I can export the data captured in each tab of a BO report to it's own file?

The code I have below does the first tab.

Dim Doc as Document
Dim Rep as Report

Set Doc = Application.Documents.Item()
Doc.Refresh
Doc.Save
Set Rep = Doc.Report.Item(1)
Rep.ExportAsText(&quot;<path>\ReportName&quot

If I add

Set Doc = Application.Documents.Open(&quot;ReportName2&quot
Doc.Refresh
Doc.Save
Set Rep = Doc.Report.Item(1)
Rep.ExportAsText(&quot;<path>\ReportName2&quot

then I can make this report open another report and export the results as text.

Any thoughts as to how I can have another 'tab' become the focus and export the results?

 

[blom0344]

Hello ainkca,

There is a pre-build export add-in available through the library section of integra-solutions (formerly

http://www.islink.com,

that link still works) Even if you do not use the add-in , you will probably be able to derive an idea from their used coding........... T. Blom
Information analyst
tbl@shimano-eu.com

 

[ainkca]

Thanks, I will try that.