I have an excel VBA macro that manages Documents, creates directory/folder structure from a specific rule, places the documents to the structure, recognizes different formats of the same document, cuts the file name if the path that is created exceeds the 255 characters and at the forth tab of the excel creates a hyperlink.

I want your help to the following:
Instead of adding a hyperlink to the last tab, i want all the information of the second tab to be added to the forth tab plus a new column to be added as first column and be the hyperlink that was created before.

The current code is the following:
Please Login or Register  to view this content.

I cannot find a way to attach the actual excel