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