Can't start multiple instances of Excel with CreateObject
 

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

Can't start multiple instances of Excel with CreateObject
 

Brian Barnett;6994608 Wrote:
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


--
Simon Lloyd

Can't start multiple instances of Excel with CreateObject
 

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

"Brian Barnett" wrote:

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

Can't start multiple instances of Excel with CreateObject
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Simon Lloyd" wrote in
message ...

Brian Barnett;6994608 Wrote:
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


--
Simon Lloyd