1. Developer's Guide
  2. About VBA Functions
  3. VBA Functions in 64-Bit Versions

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.