VBA Functions in 64-Bit Versions
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.