Can't start multiple instances of Excel with CreateObject

[Brian Barnett]

In my ASP application (Classic not .NET), I instantiate Excel as follows:

dim excelApp
set excelApp = CreateObject("Excel.Application")

When I call this ASP page simultaneously from multiple browsers, I only see
one instance of Excel in the Task Manager. Each browser waits for the
previous one to finish, i.e., it is being processed serially.

In my research, I have found that Excel is a Single Use (Multiple Instances)
server, indicating that multiple instances can be running simultaneously. Are
there settings somewhere that will allow this to happen?

I am running Excel 2003 on Windows Server 2003. Any help would be greatly
appreciated.

Thanks,
Brian Barnett

 

[Simon Lloyd]

In my ASP application (Classic not .NET), I instantiate Excel as
follows:

dim excelApp
set excelApp = CreateObject("Excel.Application")

When I call this ASP page simultaneously from multiple browsers, I only
see
one instance of Excel in the Task Manager. Each browser waits for the
previous one to finish, i.e., it is being processed serially.

In my research, I have found that Excel is a Single Use (Multiple
Instances)
server, indicating that multiple instances can be running
simultaneously. Are
there settings somewhere that will allow this to happen?

I am running Excel 2003 on Windows Server 2003. Any help would be
greatly
appreciated.

Thanks,
Brian BarnettI'm not sure on this but if you open another instance of excel from

within excel you will only be able to view the instance via the Window
selection on the
menu bar, so in my estimation you would need to open another instance
of excel by
using the Shell command, this way you should see 2 instances of excel
on your taskbar!

Regards,
Simon

 

[John Bundy]

I don't know much about ASP classic but this works for me.

On Error Resume Next

Dim excelApp
excelApp = Excel.Workbooks.Add

Try it and see, if so we both learned something.

-John

 

[Jon Peltier]

Simon -

That's not another instance of Excel, it's another workbook in the same
instance of Excel.

Brian -

I don't know why ASP sequences the new instance in that manner. Using other
VBA hosts (including Excel) I have no problem opening multiple active
instances of Excel.

- Jon