What are the differences between VBA 6.0 and VBA 7.0?

by

There’s not a whole lot that has changed between VBA6 and VBA7. VBA7 was introduced to support 64-bit versions of both Office and Windows (see below on what those differences are). Here are the key changes:

  1. 64-bit support, primarily for API
    calls    . This is both used to make your code work with your OS/Office version as well as others’ (i.e. someone on Office 2003/WinXP)

    • If you are on a 64-bit version of
      Windows, but are on a 32-bit version
      of Office, you can declare API calls
      like below.
      .

      #If Win64 Then
    Declare PtrSafe Function GetTickCount64 Lib "kernel32"() As LongLong
#Else
    Declare PtrSafe Function GetTickCount Lib "kernel32" () As Long
#End If

    • If you are on a 64-bit version of
      Windows, and are on a 64-bit version
      of Office, you can declare API calls
      like:
      .

      #If VBA7 Then
   Declare PtrSafe Function FindWindow Lib "user32" Alias "FindWindowA" ( _
       ByVal lpClassName As String, _
       ByVal lpWindowName As String) As LongPtr
 #Else
   Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal _
       lpClassName As String, ByVal lpWindowName As String) As Long
#End If

  2. To support this, there are:

    • Three new keywords (2 data types and
      1 modifier): LongPtr, LongLong and PtrSafe

    • One new function: CLngLng() (i.e.
      Int64)

    • The new compilation constants as used
      above      : VBA7 and Win64

More Related Contents:

  1. Get list of sub-directories in VBA
  2. Where does VBA Debug.Print log to?
  3. MS Access VBA Error: Run time error ’70’ Permission Denied
  4. Procedure Too Large
  5. VBA Outlook Mail .display, recording when/if sent manually
  6. Where does Outlook store the VBA code files?
  7. VBA macro that search for file in multiple subfolders
  8. Getting ScriptControl to work with Excel 2010 x64
  9. What does the Call keyword do in VB6?
  10. Transpose a range in VBA
  11. Protecting cells in Excel but allow these to be modified by VBA script
  12. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  13. How to securely store Connection String details in VBA
  14. Show “Open File” Dialog
  15. Detect merged cells in VBA Excel with MergeArea
  16. How do I name a spreadsheet automatically, by referencing two cells?
  17. Excel VBA Delete Rows
  18. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  19. Repeating random variables in VBA
  20. Should I turn .CutCopyMode back on before exiting my sub procedure?
  21. VBA: How to delete filtered rows in Excel?
  22. Determine whether user is adding or deleting rows
  23. What are possible suffixes after variable name in VBA?
  24. Removing the password from a VBA project
  25. Loop through Excel Sheets
  26. VBA Short-Circuit `And` Alternatives [duplicate]
  27. VBA Password Input with Cancel Function
  28. What does the $ symbol do in VBA?
  29. Does the bitness of the OS ever matter, or is it just the application I need to worry about?
  30. To find and replace a text in the whole document in MS Word 2010 (including tables)

Leave a Comment