Thread
:
How do i open a new instance Excel?
View Single Post
#
10
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 1,071
How do i open a new instance Excel?
Maybe, there is some option in XL that I have long since forgotten but
if not using CreateObject is SOP for starting a new instance of XL.
Another possibility is that .Net is doing something different.
One way to narrow down the source of the problem would be to
instantiate a new copy of XL from
VB
or from VBA running in another
Office program or from VBA running in XL itself. If
VB
/A works fine
then you can safely focus your attention on the .Net interface. If it
doesn't there's something about that machine / copy of XL.
One final note. You may want to ensure you have the latest support
release for your version of XL.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
am says...
Using create object did not work. I may be in the wrong group but this is
what I am doing.
I am opening an Excel workbook from a
VB
.NET program using:
_myApplaction = New Excel.Application
_myWorkbook = ._myApplaction.Workbooks.Open(ExcelWorkbookPath)
I also tried
_myApplaction = CreateObject("Excel.Application")
_myWorkbook = ._myApplaction.Workbooks.Open(ExcelWorkbookPath)
In both cases if I open a workbook file it uses the running Excel instance
you can see this by looking at the Windows menu, both files are listed there.
If I open Excel and then open the workbook, it is in a new instance in each
instance the Windows menu will only show one workbook.
Is there a way to tell excel to open a new instance when a workbook file is
opened, preferably programmability.
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta