Vic
That worked! How did you find that out? It not documented in the app
object for Excel. Infect when I look for "IgnoreRemoteRequests" in help it
did not show up. It looks like a hangover from the DDE days. I did not see
it in the intelligence scene list until you pointed it out.
Thank you,
--
Mike Reed


"Vic Eldridge" wrote:

Is there a way to tell the system to open a new Excel file in a new instance?

Yes. Application.IgnoreRemoteRequests = True


Regards,
Vic Eldridge




"Michael D. Reed" wrote:

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