Thread: Make a hyperlink macro

Hello people!

I have been working weeks to organizing huge amount of excels into one single excel using MatLab. Inside the the final excel I have been automatically generated the file-names and the paths that all the initial excels are.(This is done with matlab).

At this moment I need to put a hyperlink in all the file names I have been using, to make the final excel, to the the files that exist on my hard drive by using I suppose the list of the paths I have included in another sheet on the final excel.

I am all new to VBA and macros and I really need some help on how to do this actions automatically. Because if I have to include every hyperlink by manually it will take me years. I have been able to open the developer bar in excel and start writing macros but I really don't know what to write.

I hope that you can provide me with some Help

Thank you in advance.
Alex

There is a HYPERLINK function. Simply place in the cell next to your file path

=HYPERLINK(A1,"Open File")

Then copy the formula down the column.

Thank you for this info. It was a good info. It was the way to do it.

But I rearrange the problem a little. I did an list with all the filenames and paths in a sheet on the excel which is beeing produce automatically through matlab. And then by introducing a for loop and a character containing the string =HYPERLINK(cell1, cell2) i could able to to produce thoussands of links to the offical files in a matter of minutes. THIS IS AMAZING

THANK YOU FOR THE PUSH