If you are using the 64-bit version of Microsoft Office, VBA function declarations are slightly different from those in the 32-bit version. In 64-bit versions, the declarations include PtrSafe after the Declare keyword. For example:
32-bit version: Public Declare Function HypMenuVAbout Lib "HsAddin" () As Long
64-bit version: Public Declare PtrSafe Function HypMenuVAbout Lib "HsAddin" () As Long.
The smartview.bas file provided with your Oracle Smart View for Office installation automatically contains the appropriate declaration statements.
Note:
The code samples in this guide contain declarations for the 32-bit version of Office; if you have the 64-bit version, you must ensure that PtrSafe is included in the declarations.