When a report is scheduled, does the BCA admin have the option select Burst to PDF and-or Burst to Excel? We have some report groups that want one or the other, and some groups that want both.
ngosz 
(BOB member since 2003-09-25)
Sure, you can select the action Save as Excel and Save as PDF.
Michele Pinti (BOB member since 2002-06-17)
Perfect. I was thinking that but a couple other people were trying to convince me that it couldn’t be done.
Thanks! 
ngosz (BOB member since 2003-09-25)
What release are you running?
Michele Pinti (BOB member since 2002-06-17)
BO 5.1.8
We have the macro that bursts to PDF and Excel. I think we’d have to do a refresh of the document, burst to PDF. Then, keep the document open and burst to Excel.
ngosz (BOB member since 2003-09-25)
We do a similiar process to save as PDF and then TXT.
You can do one right after the other:
rep.ExportAsPDF (strSaveDir & “By Business Unit & Product Line.pdf”)
rep.ExportAsText (strSaveDir & “By Business Unit & Product Line.txt”)
Michele Pinti (BOB member since 2002-06-17)
I know you have to save as .txt in v5 - then export to Excel so it should be good to go.
ngosz (BOB member since 2003-09-25)
Is there a way to export multiple tabs to a single Excel file through a macro in BO6.5? I know we can Save as Excel directly under the Action tab when scheduling to BCA and get that functionality, but we need to be able to do that programatically because of some other things we’re doing in the macro. ExportAsExcel is available under Application.ActiveReport (single tab) but not under Application.ActiveDocument. Is there another way to do it? I would imagine it’s possible, I’ve just never seen any code samples of it.
Thanks in advance!
Clint
jcwoods1 (BOB member since 2004-03-03)
That did it, thanks! Very simple too 8)
jcwoods1 (BOB member since 2004-03-03)