Re: how to open workbooks with different names

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 work***
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
> >
.