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