Create hyperlink paths based on cell contents

Hi all,

I'm new to VBA and even newer to this forum (first post). I'm trying to write a macro that mainly does two things: 1) create a windows explorer folder and name it according to each cell in a column, and 2) link each cell to its corresponding folder. I have sucessfully done the first, and can do the second but only for one cell at a time.

So here's the question: How can I loop the code so that it creates a separate link for each cell?

The part that's stumping me is that the cell contents is only the destination of each path.

Example: I'm practicing this on a much smaller sheet before applying it to the large tracker at work I plan to implement it to. So right now I have a simple spreadsheet, just a list of useless folders (Folder1, Folder2, ... , Folder7) The macro now creates these seven folders in my C: drive, so the path for Folder1 is C:\Folder1 (super simple, I know, just bear with me) What I want to do is have the macro link each cell to the folders it just created, instead of manually inputing the path for every one.

So how do I create a macro that can write a link to a custom path for each cell at once? .. the destination of each path being the cell contents.

Thanks for your help, and sorry for the wall of text!

-Mike

Don't think you need a macro... i.e. If the values (Folder1) are in Column A, then in Column B you could just use:

Please Login or Register  to view this content.

Then just copy that down... should fix you right up!

Thanks that simplifies things a lot! On a semi-related note: I keep getting a #NAME? error when I try to give each link a Friendly Name. The paths I'll be dealing with when I implement this tool are long and ugly, so it would be much better to have a "Click Here" link instead of a massive path.

Thanks again.

Great, glad it helps!

Are you using?:

Please Login or Register  to view this content.