CreateObject vs "New" keyword

[vjee]

Hi,

a collegue of mine was given the advice, to use CreateObject instead of using the "new" keyword.
Dim xlObject = Excel.Application

set xlObject = CreateObject("Excel.Application&quot
set xlObject = New Excel.Application

She asked me what the advantage was of using CreateObject and why this should be used over the New keyword.

Since I don't know it, maybe somebody here knows the difference?

Thanks in advance...
Bart

 

[sunaj]

See thread222-297780 for an excellent discussion on that topic. Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[vjee]

Excellent!!!

Thanks!!