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
--
|