ajrob
09-28-2013, 10:04 AM
This should be easy, but I'm stumped. I have a "Master" copy of a .doc file that I don't want to jeopardize changing with VBA, and I don't want to use a template (.dot) because I'm not a big fan of the normal.dot conflicts.
So, the flow of the Excel VBA code is to make a copy of the master word .doc, then to transfer data from Excel to that copy.
Here's a copy of what I tried:
Sub Project_Text()
Dim objWord As Object
Set objWord = CreateObject("Word.Application")
objWord.Visible = True
objWord.Documents.Copy "C:\Master Project Text.doc"
objWord.Documents.Paste "C:\Master Project Text.doc"
So, the flow of the Excel VBA code is to make a copy of the master word .doc, then to transfer data from Excel to that copy.
Here's a copy of what I tried:
Sub Project_Text()
Dim objWord As Object
Set objWord = CreateObject("Word.Application")
objWord.Visible = True
objWord.Documents.Copy "C:\Master Project Text.doc"
objWord.Documents.Paste "C:\Master Project Text.doc"