View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default How can I create several instances of Excel ?

Hi,

How can I create several instances of Excel ? eventually 2-3 in one go ?

Usually, I do
Set oXL = WScript.CreateObject("Excel.Application")
followed by
oXL.Workbooks.Add
but, if the user has already Excel open, then my data is put in his current
workbook, no good

The should be something like oXL.Workbooks.Create but can't find it

Thanks
Raymond