Tom - Thanks for the response. This solution does allow me to create another
Excel object but the workbook with the advanced userforms still takes over
control. What the end user of this tool would like for me to do
programatically is get the same result that happends when one does
Start/Programs/Microsoft Office/Excel. This opens an entirely seperate
instance of excel (one workbook per session). Is that possible to do?
Thanks.

"Tom Ogilvy" wrote:

use createobject to open each in a separate session.

--
Regards,
Tom Ogilvy


"Pietersz" wrote:

I have an Excel workbook which uses advanced user forms. The 1st step that
takes place when the workbook is opened is to activate the 1st user form and
load it with data. The problem is that if another unrelated workbook is
opened prior to my opening this workbook, the latter one takes over control
and I can't access the 1st one. Or if I open the workbook in question 1st
and then attempt to open another workbook, it doesn't happen. The
(ALT)+(TAB) method doesn't work either. If I open up both through the
Start/Programs/Microsoft Office/Excel method, then I have access to both in
two separate sessions, which is what I want. How can I do this
programmatically? Thanks!!!