Search results
I've read that Office 2010 introduced a new VBA runtime (VB7), and that this has some new keywords that can be used in the Declare statement to allow it to work properly on 64-bit Windows. VB7 also has new predefined compiler constants to support conditional compilation where either the old or new declaration will be used, depending on whether ...
13 wrz 2021 · Please review and update Declare statements and then mark them with the PtrSafe attribute. All Declare Statements must now include the PtrSafe keyword when running in 64-bit versions of Microsoft Office.
29 mar 2022 · Required on 64-bit. The PtrSafe keyword asserts that a Declare statement is safe to run in 64-bit versions of Microsoft Office. Sub: Optional (either Sub or Function must appear). Indicates that the procedure doesn't return a value. Function: Optional (either Sub or Function must appear).
21 sty 2022 · You also need to locate and modify all data types within these Declare statements that reference handles or pointers to use the new 64-bit compatible LongPtr type alias, and types that need to hold 64-bit integrals with the new LongLong data type. Additionally, you must update any user defined types (UDTs) that contain pointers or handles and ...
27 paź 2009 · If you want to keep the 32-bit API declarations so the code continues to work on 32-bit Excel (Office <=2007), whilst also updating them to work on 32-bit or 64-bit Excel (Office >= 2010) then separate API declarations must be used with the VBA7 compiler constant:
2 lis 2017 · Declare Function SendMessage Lib "user32" Alias _. "SendMessageA" (ByVal hwnd As Long, ByVal _. wMsg As Long, ByVal wParam As Long, lParam As Any) As Long. This is a Visual Basic for Applications (VBA) code that declares several functions from the "user32" library.
While most of the things in it are still true for Office 2013, and the general recommendation remains, you can now at least now fix your DECLARE statements to work with 64-bit Office if you have to. Here's the MSDN article that covers how to do it:
