View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
fred fred is offline
external usenet poster
 
Posts: 73
Default How do i open a new instance Excel?

Micheal try,

Dim xlApp as Excel.Application
set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.Workbooks.Open FileName:="C:\Book1.xls"


Fred

"Michael D. Reed" wrote in message
...
How do I open excel workbook in its own instance of Excel. When I have
Excel
running and open another Excel workbook file (with an .xls extension) it
is
opened in the instance I have running. So, when I exit Excel both
workbooks
are closed. This is a problem when for a program that has a hidden Excel
workbook running. If I start another Excel file, it uses the instance of
Excel the program is using. This causes a problem for the program because
I
shows the hidden file and will close it if the instance is closed. If I
open
an instance of Excel then load the file, I get new instance of Excel. Is
there a way to tell the system to open a new Excel file in a new instance?
--
Mike Reed