I want to be able to hide the updating process. This invloves opening 2
files, checking specific data in each, then copying certain data from one to
the other.

The routine will be used by a number of people, some of whom would panic if
their laptop suddenly started opening and closing spreadsheets on it's own.

Thanks for the info, Jim.

BTW, I often have multiple instances of Excel open, with no problems.

--
Ian
--
"Jim Thomlinson" wrote in message
...
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
--