I would like to know how we can access a document from another program of the office suite (in this case word) from an excel spreadsheet. I know i have to allow for a certain type of code but i can't remember.
Dim wrdApp As Object
Set wrdApp = CreateObject("Word.Application")
.Visible = True
.documents.Open "Add the path to the document and its full name.doc"