Nothing has changed as regards instancing with Excel 2007. Try this in any
app that supports VB/A, even Excel

Sub test()
Dim i As Long
Dim objXL As Object

For i = 1 To 3
Set objXL = CreateObject("excel.application")

With objXL
.WindowState = -4143 ' xlNormal
.Left = i * 50
.Top = i * 50
.workbooks.Add
.Visible = True
End With
Next

End Sub

Some of our VBA application that used createObject doesn't work

Describe what you mean by "doesn't work"

Regards,
Peter T

"Jayashree Krishna" wrote in
message ...
Hi,

Some of our VBA application that used createObject doesn't work . Then we
found about the below points from Microsoft and made it to work using
getObject.
"COM servers can be classified as Multiuse (Single Instance) or Single Use
(Multiple Instances), depending on the number of instances of that server
that can run simultaneously on a single computer. "

We haven't changed anything in the OS, except upgrading Excel 2003 to
Excel
2007.Can you let me know what might have made the system to switch from
Single Use (Multiple Instances) to Multiuse (Single Instance)
automatically ? Is there any software or property to make the system
Single
Use (Multiple Instances) or Multiuse (Single Instance)

Thanks,
Krishna