Create a GUID in entire column

Hi Folks,

I've done a lot of programming and scripting, but none in Excel. I have a little experience with the VBA interface as well.

I have a spreadsheet that I use to populate a MySql database. It has a hierarchical relationship in the spreadsheet which is accomplished through a column called GUID and another column called Parent GUID. I've been using a website to generate GUIDs for me and pasting them into the first column one at a time, then copying to the second column where necessary. It takes forever.

So, I'm wondering if I can write (or better - paste!) a function that will automatically generate the first column of GUIDs. I've googled and found several functions that create a guid, but I don't really understand how to call the function from excel. Also, I don't want to manually call it thousands of times. I'd just like to call it once and have it generate GUIDs for the entire column.

I'll still copy and paste to fill in the Parent GUID column.

Thanks in advance for any help.

Terrific! Thanks a bunch!

This was a timely solution for me as well.

One more thing. Can the hyphens also be removed from the string by a function?

You help is appreciated.

I am getting an error on Windows 7 on (Compile Error: Type Mismatch on VarPtr) - I am using Option Explicit. the Definition says it is hidden:

Please Login or Register  to view this content.

thanks for the help