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