Any difference between 'New' and 'CreateObject' in automation?

[Peter]

Is there any difference between 'New' and 'CreateObject' in automation?
As in.....

Dim xlobj as Excel.application
Set xlobj = New Excel.Application
or
Set xlobj = Createobject("Excel.application")

I understand that create object is normally used in late binding but that is
not what I'm interested in.
In early binding does it matter which is used?

Pete

[Terry Kreft]

They are different.

A google search on the term
CreateObject vs New

brings up a whole slew of hits.
Essentially though, you only really need to worry about the difference if
you are coding for MTS (or COM+) applications.
--
Terry Kreft
MVP Microsoft Access
"Peter" <ru***@127.0.0.1> wrote in message
news:Ls********************@pipex.net...

Is there any difference between 'New' and 'CreateObject' in automation?
As in.....

Dim xlobj as Excel.application
Set xlobj = New Excel.Application
or
Set xlobj = Createobject("Excel.application")

I understand that create object is normally used in late binding but that is not what I'm interested in.
In early binding does it matter which is used?

Pete

[Peter]

What a good idea.......

A google search on the term
CreateObject vs New
brings up a whole slew of hits.

but it is Friday and my brain is trying to switch off.

I see what you mean now that I've looked.

Thanks

Pete