OpenJournal
Describes the Oracle Smart View for Office VBA function, OpenJournal.
Description
OpenJournal() Opens the specified journal.
Syntax
Function OpenJournal(
jrnID As String,
dims() As String,
dimVals () As String
) As Long
Parameters
jrnlID: An input argument. Provide the journal ID of the journal to be opened. Journals IDs can be obtained by calling ListJournals().
dims: An input argument. Provide the list of dimensions as an array of strings.
dimVals: An input argument. Provide the list of dimension values as an array of strings.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Sub OpenJournal
‘Firstly, get the list of Journals
ListJournals
Dim jrnlID As String
jrnlID = 1
retVal = jObj.OpenJournal(jrnlID, dims, dimVals)
If retVal = 0 Then
Debug.Print "OpenJournal Succeeded"
Else
Debug.Print "OpenJournal Failed!!!"
End If
End Sub