I don't know why you are getting that error, normally there shouldn't be any
problem to run that code with any version of Excel installed. It worked
fine for me with 2007.

However, as I mentioned before, nothing has changed as regards instancing
with Excel 2007 vs earlier versions.

Regards,
Peter T

"Jayashree Krishna" wrote in
message ...
Sorry for the delayed reply peter.
I ran the code that you sent as an Excel VBA .I got the error "Microsoft
excel encountered problem and need to close..."

On using createObject inside VBA , the excel application freezes and
close.
I know the reason is because of the Multiuse (Single Instance) or Single
Use
(Multiple Instances). I want to know what has changed the system ,that had
earlier allowed to create many instances of excel, to restrict using only
one
ionstance. Multiuse (Single Instance)
Thanks,
Krishna


"Peter T" wrote:

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


.