Thanks Paul! It worked! You're a life saver!!
Would you happen to know if it's possible to create a separate macro which would convert all my docx files to pdfs (or create new ones) using the built in microsoft 'save to pdf' plugin? I keep trying to do it by selecting all the files in explorer and then right clicking and using adobe but it keeps crashing.