how to open workbooks with different names

Hi,
I have a need to open workbooks with same names in different folders at the
same time. Is there any feature using VBA to open workbooks with different
name. I guess I could copy it with a different name before I open it. But is
there any other
way? Also I have a situation where many users will be opening these workbooks
at the same time possibly.

thanks
Kanan

If you really want to have two different workbooks with the same name, you'll
have to open two different instances of excel. This makes communicating between
them (copy|pasting even!) more difficult.

But you can start another instance by:
windows start button|Run
excel
(and hit enter)

Kanan wrote:
>
> Hi,
> I have a need to open workbooks with same names in different folders at the
> same time. Is there any feature using VBA to open workbooks with different
> name. I guess I could copy it with a different name before I open it. But is
> there any other
> way? Also I have a situation where many users will be opening these workbooks
> at the same time possibly.
>
> thanks
> Kanan

--

Dave Peterson

Please describe your typical system and if networked.
--
Jim at Eagle


"Dave Peterson" wrote:

> If you really want to have two different workbooks with the same name, you'll
> have to open two different instances of excel. This makes communicating between
> them (copy|pasting even!) more difficult.
>
> But you can start another instance by:
> windows start button|Run
> excel
> (and hit enter)
>
> Kanan wrote:
> >
> > Hi,
> > I have a need to open workbooks with same names in different folders at the
> > same time. Is there any feature using VBA to open workbooks with different
> > name. I guess I could copy it with a different name before I open it. But is
> > there any other
> > way? Also I have a situation where many users will be opening these workbooks
> > at the same time possibly.
> >
> > thanks
> > Kanan
>
> --
>
> Dave Peterson
>

Why would this matter?

Jim at Eagle wrote:
>
> Please describe your typical system and if networked.
> --
> Jim at Eagle
>
> "Dave Peterson" wrote:
>
> > If you really want to have two different workbooks with the same name, you'll
> > have to open two different instances of excel. This makes communicating between
> > them (copy|pasting even!) more difficult.
> >
> > But you can start another instance by:
> > windows start button|Run
> > excel
> > (and hit enter)
> >
> > Kanan wrote:
> > >
> > > Hi,
> > > I have a need to open workbooks with same names in different folders at the
> > > same time. Is there any feature using VBA to open workbooks with different
> > > name. I guess I could copy it with a different name before I open it. But is
> > > there any other
> > > way? Also I have a situation where many users will be opening these workbooks
> > > at the same time possibly.
> > >
> > > thanks
> > > Kanan
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Imagine a group of people on a cliff 100 feet in the high. They must leave in
alphabetical order and they hang 26 ropes off the cliff. They get in proper
line and begin descent. Sounds like good start. However, all the ropes are
25’ long.
A lot of software is created to address problems in applications design or
to overcome existing structure.
It sounded to me as if Kanan was in the middle of a descent and I was hoping
to stimulate examination of objective from start and not from present dilemma.
The concern was from “Also I have a situation where many users will be
opening these workbooks at the same time”.

--
Jim at Eagle


"Dave Peterson" wrote:

> Why would this matter?
>
> Jim at Eagle wrote:
> >
> > Please describe your typical system and if networked.
> > --
> > Jim at Eagle
> >
> > "Dave Peterson" wrote:
> >
> > > If you really want to have two different workbooks with the same name, you'll
> > > have to open two different instances of excel. This makes communicating between
> > > them (copy|pasting even!) more difficult.
> > >
> > > But you can start another instance by:
> > > windows start button|Run
> > > excel
> > > (and hit enter)
> > >
> > > Kanan wrote:
> > > >
> > > > Hi,
> > > > I have a need to open workbooks with same names in different folders at the
> > > > same time. Is there any feature using VBA to open workbooks with different
> > > > name. I guess I could copy it with a different name before I open it. But is
> > > > there any other
> > > > way? Also I have a situation where many users will be opening these workbooks
> > > > at the same time possibly.
> > > >
> > > > thanks
> > > > Kanan
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

HI Eevery one,
Sorry I was out of town for a week or so.

My environment is networked. I have different folders in the shared drive.
Each one of these folders have workbooks with same names but the content is
different. I have a command button (I call it "Drilldown") in the worksheet
in my workbook
(called Nonclinical) which will display range of options. One of the option
is to open
the workbook in one of team folders. Each team folder has a workbook called
Nonclinical. Thats where my problem is.
I hope I explained clearly.

Let me know
thanks
Kanan


"Jim at Eagle" wrote:

> Imagine a group of people on a cliff 100 feet in the high. They must leave in
> alphabetical order and they hang 26 ropes off the cliff. They get in proper
> line and begin descent. Sounds like good start. However, all the ropes are
> 25’ long.
> A lot of software is created to address problems in applications design or
> to overcome existing structure.
> It sounded to me as if Kanan was in the middle of a descent and I was hoping
> to stimulate examination of objective from start and not from present dilemma.
> The concern was from “Also I have a situation where many users will be
> opening these workbooks at the same time”.
>
> --
> Jim at Eagle
>
>
> "Dave Peterson" wrote:
>
> > Why would this matter?
> >
> > Jim at Eagle wrote:
> > >
> > > Please describe your typical system and if networked.
> > > --
> > > Jim at Eagle
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > If you really want to have two different workbooks with the same name, you'll
> > > > have to open two different instances of excel. This makes communicating between
> > > > them (copy|pasting even!) more difficult.
> > > >
> > > > But you can start another instance by:
> > > > windows start button|Run
> > > > excel
> > > > (and hit enter)
> > > >
> > > > Kanan wrote:
> > > > >
> > > > > Hi,
> > > > > I have a need to open workbooks with same names in different folders at the
> > > > > same time. Is there any feature using VBA to open workbooks with different
> > > > > name. I guess I could copy it with a different name before I open it. But is
> > > > > there any other
> > > > > way? Also I have a situation where many users will be opening these workbooks
> > > > > at the same time possibly.
> > > > >
> > > > > thanks
> > > > > Kanan
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

If you want to open multiple files with the same name in excel, you'll have to
start a different instance of excel for each of them.

A single instance of Excel won't let you open a second file that has the same
filename as an already open file.

Kanan wrote:
>
> HI Eevery one,
> Sorry I was out of town for a week or so.
>
> My environment is networked. I have different folders in the shared drive.
> Each one of these folders have workbooks with same names but the content is
> different. I have a command button (I call it "Drilldown") in the worksheet
> in my workbook
> (called Nonclinical) which will display range of options. One of the option
> is to open
> the workbook in one of team folders. Each team folder has a workbook called
> Nonclinical. Thats where my problem is.
> I hope I explained clearly.
>
> Let me know
> thanks
> Kanan
>
> "Jim at Eagle" wrote:
>
> > Imagine a group of people on a cliff 100 feet in the high. They must leave in
> > alphabetical order and they hang 26 ropes off the cliff. They get in proper
> > line and begin descent. Sounds like good start. However, all the ropes are
> > 25’ long.
> > A lot of software is created to address problems in applications design or
> > to overcome existing structure.
> > It sounded to me as if Kanan was in the middle of a descent and I was hoping
> > to stimulate examination of objective from start and not from present dilemma.
> > The concern was from “Also I have a situation where many users will be
> > opening these workbooks at the same time”.
> >
> > --
> > Jim at Eagle
> >
> >
> > "Dave Peterson" wrote:
> >
> > > Why would this matter?
> > >
> > > Jim at Eagle wrote:
> > > >
> > > > Please describe your typical system and if networked.
> > > > --
> > > > Jim at Eagle
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > If you really want to have two different workbooks with the same name, you'll
> > > > > have to open two different instances of excel. This makes communicating between
> > > > > them (copy|pasting even!) more difficult.
> > > > >
> > > > > But you can start another instance by:
> > > > > windows start button|Run
> > > > > excel
> > > > > (and hit enter)
> > > > >
> > > > > Kanan wrote:
> > > > > >
> > > > > > Hi,
> > > > > > I have a need to open workbooks with same names in different folders at the
> > > > > > same time. Is there any feature using VBA to open workbooks with different
> > > > > > name. I guess I could copy it with a different name before I open it. But is
> > > > > > there any other
> > > > > > way? Also I have a situation where many users will be opening these workbooks
> > > > > > at the same time possibly.
> > > > > >
> > > > > > thanks
> > > > > > Kanan
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >

--

Dave Peterson

I recommend you not be afraid to rename all files with a naming rhythm easily
understood. Program your workbook to retrieve other workbooks using an
interpreter in your menu. For example all workbooks are named following the
name from your server station ID and this correlates with a drop down list in
your workbook with a personal name or office station that is familiar to you.
If you anticipate a strong growth in workbooks, correcting this deficiency
sooner is best.
Good luck,

--
Jim at Eagle


"Kanan" wrote:

> HI Eevery one,
> Sorry I was out of town for a week or so.
>
> My environment is networked. I have different folders in the shared drive.
> Each one of these folders have workbooks with same names but the content is
> different. I have a command button (I call it "Drilldown") in the worksheet
> in my workbook
> (called Nonclinical) which will display range of options. One of the option
> is to open
> the workbook in one of team folders. Each team folder has a workbook called
> Nonclinical. Thats where my problem is.
> I hope I explained clearly.
>
> Let me know
> thanks
> Kanan
>
>
> "Jim at Eagle" wrote:
>
> > Imagine a group of people on a cliff 100 feet in the high. They must leave in
> > alphabetical order and they hang 26 ropes off the cliff. They get in proper
> > line and begin descent. Sounds like good start. However, all the ropes are
> > 25’ long.
> > A lot of software is created to address problems in applications design or
> > to overcome existing structure.
> > It sounded to me as if Kanan was in the middle of a descent and I was hoping
> > to stimulate examination of objective from start and not from present dilemma.
> > The concern was from “Also I have a situation where many users will be
> > opening these workbooks at the same time”.
> >
> > --
> > Jim at Eagle
> >
> >
> > "Dave Peterson" wrote:
> >
> > > Why would this matter?
> > >
> > > Jim at Eagle wrote:
> > > >
> > > > Please describe your typical system and if networked.
> > > > --
> > > > Jim at Eagle
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > If you really want to have two different workbooks with the same name, you'll
> > > > > have to open two different instances of excel. This makes communicating between
> > > > > them (copy|pasting even!) more difficult.
> > > > >
> > > > > But you can start another instance by:
> > > > > windows start button|Run
> > > > > excel
> > > > > (and hit enter)
> > > > >
> > > > > Kanan wrote:
> > > > > >
> > > > > > Hi,
> > > > > > I have a need to open workbooks with same names in different folders at the
> > > > > > same time. Is there any feature using VBA to open workbooks with different
> > > > > > name. I guess I could copy it with a different name before I open it. But is
> > > > > > there any other
> > > > > > way? Also I have a situation where many users will be opening these workbooks
> > > > > > at the same time possibly.
> > > > > >
> > > > > > thanks
> > > > > > Kanan
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >

thanks for all your feedback.
kanan
"Jim at Eagle" wrote:

> I recommend you not be afraid to rename all files with a naming rhythm easily
> understood. Program your workbook to retrieve other workbooks using an
> interpreter in your menu. For example all workbooks are named following the
> name from your server station ID and this correlates with a drop down list in
> your workbook with a personal name or office station that is familiar to you.
> If you anticipate a strong growth in workbooks, correcting this deficiency
> sooner is best.
> Good luck,
>
> --
> Jim at Eagle
>
>
> "Kanan" wrote:
>
> > HI Eevery one,
> > Sorry I was out of town for a week or so.
> >
> > My environment is networked. I have different folders in the shared drive.
> > Each one of these folders have workbooks with same names but the content is
> > different. I have a command button (I call it "Drilldown") in the worksheet
> > in my workbook
> > (called Nonclinical) which will display range of options. One of the option
> > is to open
> > the workbook in one of team folders. Each team folder has a workbook called
> > Nonclinical. Thats where my problem is.
> > I hope I explained clearly.
> >
> > Let me know
> > thanks
> > Kanan
> >
> >
> > "Jim at Eagle" wrote:
> >
> > > Imagine a group of people on a cliff 100 feet in the high. They must leave in
> > > alphabetical order and they hang 26 ropes off the cliff. They get in proper
> > > line and begin descent. Sounds like good start. However, all the ropes are
> > > 25’ long.
> > > A lot of software is created to address problems in applications design or
> > > to overcome existing structure.
> > > It sounded to me as if Kanan was in the middle of a descent and I was hoping
> > > to stimulate examination of objective from start and not from present dilemma.
> > > The concern was from “Also I have a situation where many users will be
> > > opening these workbooks at the same time”.
> > >
> > > --
> > > Jim at Eagle
> > >
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > Why would this matter?
> > > >
> > > > Jim at Eagle wrote:
> > > > >
> > > > > Please describe your typical system and if networked.
> > > > > --
> > > > > Jim at Eagle
> > > > >
> > > > > "Dave Peterson" wrote:
> > > > >
> > > > > > If you really want to have two different workbooks with the same name, you'll
> > > > > > have to open two different instances of excel. This makes communicating between
> > > > > > them (copy|pasting even!) more difficult.
> > > > > >
> > > > > > But you can start another instance by:
> > > > > > windows start button|Run
> > > > > > excel
> > > > > > (and hit enter)
> > > > > >
> > > > > > Kanan wrote:
> > > > > > >
> > > > > > > Hi,
> > > > > > > I have a need to open workbooks with same names in different folders at the
> > > > > > > same time. Is there any feature using VBA to open workbooks with different
> > > > > > > name. I guess I could copy it with a different name before I open it. But is
> > > > > > > there any other
> > > > > > > way? Also I have a situation where many users will be opening these workbooks
> > > > > > > at the same time possibly.
> > > > > > >
> > > > > > > thanks
> > > > > > > Kanan
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Dave Peterson
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >