On Mon, 11 Sep 2006, demerphq wrote:
> On 9/11/06, Nicholas Clark <[email protected]> wrote:
> > A document with the name 'TS_200609_NWC.xls' is already open
> >
> > You cannot open two documents with the same name,
> > even if the documents are in different folders.
> > To open the second document, either close the document
> > that's currently open, or rename one of the documents.
> >
> >
> >
> > People *pay* money for this? Positive sums of money?
>
> Insane isn't it? I hate it too.
>
> I blame the VB scripting model and marketing. They could have had it said
>
> Warning, another different file of this name is already open.
> Internally Excel will use 'BLORG' as the name. This may break some
> user defined macros. If this is a problem close the other file before
> opening this one. Should I proceed?
>
> OK - CANCEL
A (possibly) easier fix (for MS to implement):
* On first save, embed a UUID in the header of the .xls file.
* Provide the option -- preferably in some user- / scripter- friendly
way that doesn't necessarily expose the UUID or force typing it out
when needed -- to attach macros to UUIDs rather than file names.
This should solve the current problem, and if VBA macros are attached to
file names and (presumably) break if the file is renamed, then it would
solve that problem too.
--
Chris Devers
