I have a macro i'm running in excel that loads up a document template i've created. I have a word table at the top of this document that I want to add text to from the excel user form I've designed. My code to select the cell in the table on the word document works but the code to insert the text doesn't.
Can anyone help? Code is below:
Set MyWrd = GetObject(SavePathAndName) 'Open Newly Created Document
MyWrd.Application.Visible = True
'Add Document info to Table Cells
Selection.Text = Issue_box1.Value 'This Line doesn't work