Excel VBA 32-Bit to 64-Bit

Question

I have a old Excel file with 32-bit code. Who can turn this into 64-Bit code?

Private Declare Function SetWindowPos Lib "user32" ( _
                 ByVal hWnd As Long, _
                 ByVal hWndInsertAfter As Long, _
                 ByVal x As Long, _
                 ByVal y As Long, _
                 ByVal cx As Long, _
                 ByVal cy As Long, _
                 ByVal wFlags As Long) _
                 As Long
Private Declare Function GetSystemMetrics Lib "user32" (ByVal nIndex As Long) As Long

Thanks for your help

Maybe this sheds some more light on the issue. In this case you need to change Longptr for hwnd and hWndInsertAfter. And you need to add the keyword Ptrsafe. — Storax
– Storax, Commented Jun 20, 2024 at 9:45
Really helpful with many examples is JKP's article Declaring API functions for 64 bit Office and Mac Office — T.M.
– T.M., Commented Jun 20, 2024 at 10:02
The original Microsoft link has been retired but I created a gist to hold useful API declarations. — Cristian Buse
– Cristian Buse, Commented Jun 20, 2024 at 15:06
@T.M. I simply saved the file in the same state as I downloaded from Microsoft many years ago. The copyright from Microsoft is at the top of the file so I did not think to mention - I did not write any line of code :) But the documentation is indeed impressive. — Cristian Buse
– Cristian Buse, Commented Jun 20, 2024 at 17:35

Storax · Accepted Answer · 2024-06-20 09:51:36Z

0

In this case it is

Declare PtrSafe Function SetWindowPos Lib "user32" _
    (ByVal hwnd As LongPtr, _
    ByVal hWndInsertAfter As LongPtr, _
    ByVal x As Long, ByVal y As Long, _
    ByVal cx As Long, _
    ByVal cy As Long, _
    ByVal wFlags As Long) As Long

Declare PtrSafe Function GetSystemMetrics Lib "user32" _
    (ByVal nIndex As Long) As Long

Collectives™ on Stack Overflow

Excel VBA 32-Bit to 64-Bit

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related