Consulting

Results 1 to 3 of 3

Thread: Oorang: A query about your GUID program

  1. #1
    VBAX Expert
    Joined
    Aug 2007
    Location
    Windermere, FL, a 'burb in the greater Orlando metro area.
    Posts
    567
    Location

    Oorang: A query about your GUID program

    Oorang,

    I borrowed your code from your kb article: Create a GUID (Globally Unique Identifier). I'm using it in a vba macro that reads through a file and assigns a GUID to any record in the file that doesn't have one.

    I noticed that your code produces GUIDS that are capitalized; is there a way (short of resorting to regular expressions) to get the GUID in lower case?

    Thanks,
    Ron
    Windermere, FL

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Why notjust

    [vba]

    Public Function GetGUID() As String
    GetGUID = LCase(Mid$(CreateObject("Scriptlet.TypeLib").GUID, 2, 36))
    End Function
    [/vba]
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Jun 2007
    Posts
    69
    Location
    Bob,

    Yes, why not.

    (I'll just die of embarrassment, now, and not blame the late hour and my brain having shut down for the night, etc.)

    Thanks,
    Ron McKenzie
    Windermere, FL
    (living in the huge shadow of a tiny rodent)

Posting Permissions

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