Unique File Identifier

[Jörgen Ahrens]

Hi all

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

thanks for your help
J. Ahrens

[Chip Pearson]

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" <jahrens@community.nospam> wrote in message
news:ukw7PHa%23FHA.1140@tk2msftngp13.phx.gbl...
> Hi all
>
> Is there a way to uniquly identify an excel-file? (like
> inode-id in unix)
>
> thanks for your help
> J. Ahrens
>

[quartz]

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
>
>
>

[Jörgen 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" <chip@cpearson.com> wrote in message
news:eVT6OMa%23FHA.2916@TK2MSFTNGP10.phx.gbl...
> 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" <jahrens@community.nospam> wrote in message
> news:ukw7PHa%23FHA.1140@tk2msftngp13.phx.gbl...
>> Hi all
>>
>> Is there a way to uniquly identify an excel-file? (like inode-id in unix)
>>
>> thanks for your help
>> J. Ahrens
>>
>
>