Create hyperlinks for your files and directories in Excel using macro
After we created a batch file to get the names of files in a directory and its subdirectories and store it in a file, now it is time to copy the list to an Excel sheet and batch create hyperlinks for all the files in the Excel sheet.
In this video will examine the use of wildcards in the search to modify the search and get a selected files type or names, then a macro is used to create the hyperlinks to open each file.
First we use the “record macro” feature to learn the method to create a hyperlink then we use the same technique to create the hyperlinks for the rest of files and directories in one shot.