Hi All,
I am using Access 2007 VBA to open Business Objects XI and run multiple reports. I have accomplished this successfully, however all BO reports has a user input required prompt. This prompt will be the same throughout all BO reports, so I would like to have a user input the date in Access and call that input when required in the BO report.
Below is my code that opens a user input box for the date in access, opens Business Objects, calls up one BO report, logs in with a specified username and password, and I need to figure out how to use sDate when prompted in Business Objects :
Sub Run_Business_Objects()
Dim BoApp As Object
Dim sDate As String
sDate = InputBox(Prompt:="Please Enter the Last Business Day (MM/DD/YYYY).")
Set BoApp = CreateObject("BusinessObjects.application")
With BoApp
.Visible = True
.LoginAs "username", "password", , "system"
.Documents.Open ("C:\Documents and Settings...\.rep")
\\\\Call Variable Here????\\\\\\
End With
End Sub
I am using Access 2007 VBA to open Business Objects XI and run multiple reports. I have accomplished this successfully, however all BO reports has a user input required prompt. This prompt will be the same throughout all BO reports, so I would like to have a user input the date in Access and call that input when required in the BO report.
Below is my code that opens a user input box for the date in access, opens Business Objects, calls up one BO report, logs in with a specified username and password, and I need to figure out how to use sDate when prompted in Business Objects :
Sub Run_Business_Objects()
Dim BoApp As Object
Dim sDate As String
sDate = InputBox(Prompt:="Please Enter the Last Business Day (MM/DD/YYYY).")
Set BoApp = CreateObject("BusinessObjects.application")
With BoApp
.Visible = True
.LoginAs "username", "password", , "system"
.Documents.Open ("C:\Documents and Settings...\.rep")
\\\\Call Variable Here????\\\\\\
End With
End Sub