a student gave me the following script to automate refresh of a report :
Sub RefreshBO()
Dim objBO, objrep
Application.DisplayAlerts = False
'Open Business ObjectSet objBO = CreateObject("BusinessObjects.Application")
' (when update to version 6)' Set objBO = CreateObject("BusinessObjects.Application.6")
objBO.LoginAs "username", "password", False' (fill in username and password)
'open the report
objrep = objBO.Documents.Open("c:\myfile.rep")
'Show BO
objBO.Visible = True
'Refresh Report
objrep.Refresh
'Save Report
objrep.Save
'Close Report
objrep.Close
great !!
Geen opmerkingen:
Een reactie posten