Hello. I have created a drop down list in Excel that I would like to open different Word templates when selected. Here is my code for opening the word document, what else would I need to add to make this happen?
Set WrdApp = CreateObject("Word.Application")
WrdApp.Visible = True
Set WrdDoc = WrdApp.Documents.Open("C:\Users\" & UserID & "\Desktop\Quantien Evaluation with Certus and WiBox Template.docx")
Set WrdApp = CreateObject("Word.Application")
WrdApp.Visible = True
Set WrdDoc = WrdApp.Documents.Open("C:\Users\" & UserID & "\Desktop\Quantien Evaluation with Certus and WiBox Template.docx")