Hi,
I am new at this and have just started to use Business Objects and visual Basic. I have the code below in place to open a report in business object and export it to text and the code is working just fine. I just want to edit the code but once I open the report the macro starts to run and it generates the report and closes Business Object. How can I work on the VB code without having the report run? The report takes more than an hour to run so it is kind of frustrating.
Private Sub Document_Open()
Application.BreakOnVBAError = False
Application.Interactive = False
Dim Doc As Document
Dim Rep As Report
Set Doc = Application.Documents.Item(1)
Doc.Refresh
Doc.Save
Set Rep = Doc.Reports.Item(1)
Rep.ExportAsText ("C:\TEST\test.txt")
Application.Quit
End Sub
I am new at this and have just started to use Business Objects and visual Basic. I have the code below in place to open a report in business object and export it to text and the code is working just fine. I just want to edit the code but once I open the report the macro starts to run and it generates the report and closes Business Object. How can I work on the VB code without having the report run? The report takes more than an hour to run so it is kind of frustrating.
Private Sub Document_Open()
Application.BreakOnVBAError = False
Application.Interactive = False
Dim Doc As Document
Dim Rep As Report
Set Doc = Application.Documents.Item(1)
Doc.Refresh
Doc.Save
Set Rep = Doc.Reports.Item(1)
Rep.ExportAsText ("C:\TEST\test.txt")
Application.Quit
End Sub