What are the differences between using the New keyword and calling CreateObject in Excel VBA?

by

As long as the variable is not typed as object

Dim xmlDocument as MSXML2.DOMDocument
Set xmlDocument = CreateObject("MSXML2.DOMDocument")

is the same as

Dim xmlDocument as MSXML2.DOMDocument
Set xmlDocument = New MSXML2.DOMDocument

both use early binding. Whereas

Dim xmlDocument as Object
Set xmlDocument = CreateObject("MSXML2.DOMDocument")

uses late binding. See MSDN here.

When you’re creating externally provided objects, there are no differences between the New operator, declaring a variable As New, and using the CreateObject function.

New requires that a type library is referenced. Whereas CreateObject uses the registry.

CreateObject can be used to create an object on a remote machine.

More Related Contents:

  1. Getting ScriptControl to work with Excel 2010 x64
  2. Calling regasm without administrative rights for COM interop in Excel VBA
  3. delete Autofilter Field resullt using the header Name
  4. Somehow it’s not copying [closed]
  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. Application.Match gives type mismatch
  8. Count and Highlight keywords within phrases
  9. Transpose a range in VBA
  10. Detect merged cells in VBA Excel with MergeArea
  11. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  12. Parse HTML content in VBA
  13. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  14. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  15. Should I turn .CutCopyMode back on before exiting my sub procedure?
  16. Determine whether user is adding or deleting rows
  17. How to use VBA SaveAs without closing calling workbook?
  18. Removing the password from a VBA project
  19. Removing special characters VBA Excel
  20. Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
  21. Iterate over slicer via VBA and select a single item each time
  22. Return a range from A1 to the true last used cell
  23. How to add items to a combobox in a form in excel VBA?
  24. How can I automate Save as dialog box in IE11 using VBA?
  25. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  26. How do I activate a specific workbook and a specific sheet?
  27. Start VBA macro when editing a cell
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment