Hi all

Is there a way to uniquly identify an excel-file? (like inode-id in unix)

thanks for your help
J. Ahrens

What about the file name? Beyond that, you'd have to write some
sort of encoding identifier. Excel doesn't provide anything.


"Jörgen Ahrens" wrote in message
...
Hi all

Is there a way to uniquly identify an excel-file? (like
inode-id in unix)

thanks for your help
J. Ahrens

the problem is, that i'll have a database where the file has an id. if
someone changes the filename in an explorer window i woudn't get en event or
something to foward that change into my database and therefore loose my
connection(by name)...is there a way to bind the excel file somehow to the
database. do you have any souggestions?

thanks
J. Ahrens

"Chip Pearson" wrote in message
...
What about the file name? Beyond that, you'd have to write some sort of
encoding identifier. Excel doesn't provide anything.


"Jörgen Ahrens" wrote in message
...
Hi all

Is there a way to uniquly identify an excel-file? (like inode-id in unix)

thanks for your help
J. Ahrens

One possible method is to use the FileSearch method to look for the file
containing specific and unique text you plant in the file somewhere.

One technique I have used is to create a custom document property, it is
easy to code and most users are not aware they exist so they are unobtrusive
and not very prone to intentional or accidental deletion. The weakness in
this method is that the files must be sequentially opened to see if they
contain the property, but if you at least know the folder in which to look,
it is not a bad approach.

Just some ideas. HTH.


"Jörgen Ahrens" wrote:

Hi all

Is there a way to uniquly identify an excel-file? (like inode-id in unix)

thanks for your help
J. Ahrens