Thread
:
Unique ID
View Single Post
#
1
Posted to microsoft.public.excel.programming
Michel Pierron[_2_]
external usenet poster
Posts: 63
Unique ID
Hi Ron,
You can test
Sub CreateGUID()
MsgBox Left(CreateObject("Scriptlet.TypeLib").GUID, 38)
End Sub
Regards,
MP
"Ron Rasmussen" <Ron
a écrit dans le message
de ...
I am trying to insert a unique ID for each row in multiple sheets that are
not connected but the data will later be combined (so I need the unique ID to
be unique).
I thought I would use the following code:
Dim GId As Guid = Guid.NewGuid() but I get an error message that it is not
supported in VBA.
I'm sure many people have this same problem and there must be a preferred
method.
I would appreciate any advise.
Ron
Reply With Quote
Michel Pierron[_2_]
View Public Profile
Find all posts by Michel Pierron[_2_]