How to convert 32 bit VBA code into 64 bit VBA code

by

These should work on 64 bit Excel

Private Declare PtrSafe Function FindWindowEx Lib "user32" Alias "FindWindowExA" _
  (ByVal hWnd1 As LongPtr, ByVal hWnd2 As LongPtr, ByVal lpsz1 As String, _
  ByVal lpsz2 As String) As LongPtr

Private Declare PtrSafe Function IIDFromString Lib "ole32" _
  (ByVal lpsz As LongPtr, ByRef lpiid As GUID) As Long

Private Declare PtrSafe Function AccessibleObjectFromWindow Lib "oleacc" _
  (ByVal Hwnd As LongPtr, ByVal dwId As Long, ByRef riid As GUID, _
  ByRef ppvObject As Object) As Long

If you need it to run on both you can use the following #If VBA7

#If VBA7 Then
    '64 bit declares here
#Else
    '32 bit declares here
#End If

A nice resource for PtrSafe Win32 API declares can be found here: Win32API_PtrSafe.txt

More Related Contents:

  1. How to color all the rows based on the cell values
  2. How to get MS Excel to list files in a folder with their metadata (in particular, the tags created for the files)?
  3. Excel – opening file stuck on 100%, until VBA code finishes
  4. How to add a reference programmatically using VBA
  5. Copy Paste Values only( xlPasteValues )
  6. automatically execute an Excel macro on a cell change
  7. VLOOKUP with multiple criteria returning values in one cell
  8. How can I concatenate strings in VBA?
  9. Copy/Paste/Calculate Visible Cells from One Column of a Filtered Table
  10. Loading addins when Excel is instantiated programmatically
  11. Excel’s fullname property with OneDrive
  12. Trying to use variables as values vba to sql
  13. Copy Excel range as Picture to Outlook
  14. VBA (Excel) Dictionary on Mac?
  15. Return RGB values from Range.Interior.Color (or any other Color Property)
  16. Refresh Excel VBA Function Results
  17. excel VBA run macro automatically whenever a cell is changed
  18. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  19. Translate text using vba
  20. Delete all duplicate rows Excel vba
  21. Excel VBA: Convert a date string to a Unix timestamp
  22. excel to pdf ignores print area and calls printer
  23. In Excel, can I use a hyperlink to run vba macro?
  24. Excel VBA – exit for loop
  25. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  26. Best way to protect Excel VBA code? [closed]
  27. VBA copy rows that meet criteria to another sheet
  28. VBA Dialog box to select range in different workbook
  29. VBA: Remove duplicates fails when columns array is passed using a variable
  30. How to protect Excel workbook using VBA?

Leave a Comment