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

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

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

Yes, that is exactly what createobject does.

--
Regards,
Tom Ogilvy



"Pietersz" wrote in message
...
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!!!