Thanks Steve. The W: reference does not appear to be a problem as I can see in the VBA window that the report is opening successfully.
It seems to be something that the BCA does not like about using the custom script. I've tried it without the custom script but this does not work either.
Simon.
I am using the following code to refresh a BO report:
Sub RefreshReport()
Dim var As DocAgentOption
Dim DocName As String
DocName = "W:\BusinessObjects\UserDocs\New KPI Files\Apac2005.rep"
Application.Documents.Open (DocName)
Set var = ActiveDocument.DocAgentOption
var.ResetToDefault...
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.