How to do late binding in VBA?

by

This is early binding:

Dim olApp As Outlook.Application
Set olApp = New Outlook.Application

And this is late binding:

Dim olApp As Object
Set olApp = CreateObject("Outlook.Application")

Late binding does not require a reference to Outlook Library 16.0 whereas early binding does. However, note that late binding is a bit slower and you won’t get intellisense for that object.

More Related Contents:

  1. Download attachment from Outlook and Open in Excel
  2. Embed picture in outlook mail body excel vba
  3. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  4. How to copy Outlook mail message into excel using VBA or Macros
  5. VBA macro that search for file in multiple subfolders
  6. So, I have 6 “master” files to then divide into 40 separate files
  7. Getting ScriptControl to work with Excel 2010 x64
  8. Application.Match gives type mismatch
  9. Count and Highlight keywords within phrases
  10. Transpose a range in VBA
  11. Detect merged cells in VBA Excel with MergeArea
  12. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  13. Parse HTML content in VBA
  14. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  15. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  16. Should I turn .CutCopyMode back on before exiting my sub procedure?
  17. Determine whether user is adding or deleting rows
  18. How to use VBA SaveAs without closing calling workbook?
  19. Round function in Excel, worksheet function vs VBA
  20. How to continue the code on the next line in VBA
  21. Excel VBA Userform – Execute Sub when something changes
  22. Count the number of rows in another sheet [duplicate]
  23. Search structured text in Outlook body
  24. VBA Password Input with Cancel Function
  25. Finding first blank row, then writing to it
  26. Debugging an Outlook 2007 script fired by a rule
  27. Calling regasm without administrative rights for COM interop in Excel VBA
  28. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  29. How do I activate a specific workbook and a specific sheet?
  30. Start VBA macro when editing a cell

Leave a Comment