Thread: Unique ID
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michel Pierron[_2_] Michel Pierron[_2_] is offline
external usenet poster
 
Posts: 63
Default 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