Hello,
I have a list of hyperlinks to documents in an excel column that i created by specifying the folder path then adding the doc names and ".doc" to the end. However, some of the links are broken since some of the documents have a ".docx" instead. Is there a way to go through the list, check if the link works, and if not, change the ending from ".doc" to ".docx" ?
Thank you
I have a list of hyperlinks to documents in an excel column that i created by specifying the folder path then adding the doc names and ".doc" to the end. However, some of the links are broken since some of the documents have a ".docx" instead. Is there a way to go through the list, check if the link works, and if not, change the ending from ".doc" to ".docx" ?
Thank you
