VBA code to export all report tabs to Excel

system · December 28, 2006, 7:32pm

Working on Business Objects 6.5 SP3

Looking for VBA code to export the entire report (all report tabs) into Excel format. I currently use the following to export one report tab:

ThisDocument.Reports.Item(“Report1”).Activate
ThisDocument.ActiveReport.ExportAsText (OutputFile)

nell (BOB member since 2005-09-08)

system · December 28, 2006, 7:46pm

Hi and welcome to B B

Have you tried BOB’s search

Doing so you would have found at least these posts:

Marek Chladny (BOB member since 2003-11-27)