Thread: Opening Multiple Sessions of Excel

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" <pietersz@discussions.microsoft.com> wrote in message
news:4759E5E4-3A3A-4ADA-8DA1-EB2FA9F02979@microsoft.com...
> 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!!!