How to generate a unique ID on a Excel for identification purpose
Results 1 to 4 of 4

Thread: How to generate a unique ID on a Excel for identification purpose
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2004
    Posts
    669
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to generate a unique ID on a Excel for identification purpose

    Some dept will send me several version of Excel repeatedly whenever they have update.
    I need to identify which one is which version. So, is it possible once I receive it, Excel has some kind of ID of this file I can copy out to ensure this one is this version other than using file name which user can change easily ?
    Eg something I include in the file like [FilelastsaveDate] (In fact I still do not know how to do it, coz =now() keeps changing) & [FileSize] in a ID tab to identify it etc ?
    Anything better than this ?
    Any thought ? Due to policy, VBA is not allowed
    Thanks
    Last edited by mrchonginhk; Jul 21st, 2019 at 08:49 PM.

  2. #2
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,728
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to generate a unique ID on a Excel for identification purpose

    .
    Too bad you can't utilize a VBA macro :

    Code:
    Sub MyVersion()
        MsgBox Application.Version
    End Sub

    This formula will give you the version number as well :

    Code:
    =INFO("release")
    https://corporatefinanceinstitute.co...info-function/

  3. #3
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,149
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: How to generate a unique ID on a Excel for identification purpose

    Maybe just look at the file's time stamp (of when last saved)?
    To receive a better answer, put more work into asking the question.


  4. #4
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,728
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to generate a unique ID on a Excel for identification purpose

    .
    Ok ... I messed that one up ! Completely misunderstood what you were seeking.

    Take a look at this :

    https://www.techonthenet.com/excel/m...t_modified.php

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •