View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Force new Excel instance

Yes but why do you want to. Generally speaking having multiple instances of
XL running causes more issues than it solves...

sub Test
dim xlApp as object
dim wbk as workbook

set xlApp = createobject("Excel.Application")
xlApp.visible = true
set wbk = xlApp.Workbooks.open("C:\Test.xls")
end sub

--
HTH...

Jim Thomlinson


"IanC" wrote:

Is it possible to force a new instance of Excel to be opened when a file is
opened via VBA?

Many thanks.

--
Ian
--