Skylar
asked on
How to add PtrSafe to make this work in 64 bit
I have this part of the code which is for 32 bit Excel and my excel is 64 bit,
I tried to make this 64 bit by adding PtrSafe at the beginining of the code. it did not work for me.
can anyone please help me?
I tried to make this 64 bit by adding PtrSafe at the beginining of the code. it did not work for me.
can anyone please help me?
Private Declare Function GetDesktopWindow Lib "user32" () As Long
Private Declare Function ShellExecute Lib "shell32" _
Alias "ShellExecuteA" _
(ByVal hwnd As Long, _
ByVal lpOperation As String, _
ByVal lpFile As String, _
ByVal lpParameters As String, _
ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much Daniel. It solved the problem.
Open in new window
For both version you could use a conditional declaration like :
Open in new window