Registering the Oracle Journals VBA Functions Using RegAsm
Before you begin creating and editing VBA functions for Oracle Journals for Financial Management, you must register the Oracle Journals for Financial Management DLL using RegAsm.
To register the Oracle Journals DLL using RegAsm:
Note the file location of the Oracle Journals DLL (Journals.dll); generally, located in:
From Windows Explorer, navigate to the Oracle Smart View for Office installation directory; generally located in:
C:\Oracle\SmartView\bin
Copy the Oracle.SmartView.Interop.SVRC.dll file from this location to the Oracle Journals file location noted in step 1.
As administrator, open a command prompt and navigate to one of the following locations:
For Microsoft Office 64-bit:
C:\Windows\Microsoft.NET\Framework64\v4.0.30319
For Microsoft Office 32-bit:
C:\Windows\Microsoft.NET\Framework\v4.0.30319
Execute the following command:
regasm /codebase /tlb <file path from Step 1>\Journals.dll
You should see this message:
"Assembly exported to %APPDATA%\Oracle\SmartView\extensions\Bin\Oracle.SmartView.SVFMJournal\bin\Journals.tlb and the type library was registered successfully."