View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_899_] Simon Lloyd[_899_] is offline
external usenet poster
 
Posts: 1
Default 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