To start I am a novice at any type of coding and am starting to learn. I have borrowed the code below.
I have an Excel workbook with a button to allow the contents of the table to be exported to Word. The contents on the table are hyperlinked in Excel and when exported to Word the hyperlinks change to Absolute paths. I need to keep them relative. I have done some research and have found that it has to be saved as a .doc file not a .docx. Can somebody look at the code I have a guide me how to ensure that the Word document is automated to be saved as a .doc?