I currently have a BO report which refreshes on a dailly basis and save/re-writes itself back to the server. Is it possible for this file t export to excel/txt/csv automatically as well when it refreshes?
Certainly is, you'll need to stick some vba code into the after refresh document action.
Your code will probably be something like this:
Dim Doc As Document
Dim Rep As Report
Set Doc = Application.Documents.Item(1)
Set Rep = Doc.Reports.Item(1)
Rep.ExportAsText ("Filepath\Filename" + ".xls"
VBA ???
A Macro currently does this, is it the same thing?
sorry, I'm pretty new to all this, code of Macro:
Application.Documents.Open("E:\TEMP.rep"
Application.Documents.Open("E:\TEMP.rep".Refresh
Application.Documents.Open("E:\TEMP.rep".Save
Application.Documents.Open("E:\TEMP.rep".SaveAs "E:\TEMP.rep", True
Application.Documents.Open("E:\TEMP.rep".Close
VBA? Visual Basic for Applications - most macros use this as the're language.
Right click in your Business Objects toolbar, select Visual Basic Toolbar, click on the white box with the bluetop and red bit coming out of top (Visual Basic Editor)
The code goes into a window on the right hand side of the visual basic editor.
You need to insert the code into a sub routine, you can make your own or use one of the docuement event ones....
The above code seems to save the report as a BO report as opposed to converting it to excel.
A basic rundown of what my coding does
dim doc as document
dim rep as report
declares two variables one relating to a document one relating to a report
set doc and set rep declares what these variables should be
Rep.ExportAsText ("Filepath\Filename" + ".xls" exports the document as text but because of the.xls tag the information is put into a spreadsheet (text delimited)
Your macro code is refreshing your document and saving that document as Business Objects document. After refreshing your Buiness Objects document, you have to export it to excel.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.