Create hyperlink automatically by copy paste files path from computer

An alternative mthod is to synchronize directory by using VBA after work every day.

Please Login or Register  to view this content.

Thank you 😊 The problem is that i have the reports in several folders, but i find other way that i think works good for me, that would be to go each folder and use the command copy path of the files (from windows) and then i past in excel like this for example

cell A1 = "D:\Users\ertas\Downloads\019333289.docx"
cell A2 = "D:\Users\ertas\Downloads\019376.docx"
cell A3 = "D:\Users\reports\2346.docx"

and i would have a macro that i select the cells for example A1 to A3, and it would automatically convert them in hyperlink with the text:


cell A1 = 019333289.docx
cell A2 = 019376.docx
cell A3 = 2346.docx

then the macro would also change the cells from vertical to horizontal, like this:

cell A1 = 019333289.docx
cell B1 = 019376.docx
cell C1 = 2346.docx

Just have to learn now, how to do it with macro😅

How about?
1. select cells
2. Alt-F8 run macro

Please Login or Register  to view this content.

Wow 😍😍😍 You're the best!!

This is simply perfect! Completely solved my problem and saved me a lot of time! 😊

I feel bad asking for one more thing, but maybe its not hard that would be to put also in the macro to rotate at the end the selected cells from rows into columns.
transpose the select cells from columns into rows .

For example, when i copy paste in excel the paths of the files from the folders, they are alligned in collumns like A1, A2, A3, etc...then i run the macro , hyperlinks are created and i would like then at the end the data to be A1, B1, C1, or whatever cells i selected before running the macro, for example, C21,C22,C23 to transform in C21, D21, EE21

I found online an article about the command TRANSPOSE, maybe that is the right command...or if not possible i can always copy, and paste special and select transpote.

In any case, you really helped me a lot, and i gained around 15 minutes per day just using this macro! Thank you so much, really! 😍

Please Login or Register  to view this content.

This one does rotates the selected cells from rows into columns and creates hyperlinks, but it shows the full path for example "D:\Users\ertas\Downloads\019333289.docx" instead of showing 019333289.docx shows "D:\Users\ertas\Downloads\019333289.docx"

I'll just use the first one Thank you so much, i'm in debt to you 😊

I did not notice

Please Login or Register  to view this content.

Solved it! Thank you so much 😍 I really really appreciate your help! 😊

You are welcome.