I have the following
Dim objWord As Word.Application
Dim doc As Word.Document
Dim WordHeaderFooter As HeaderFooter
Set objWord = CreateObject("Word.Application")
.Visible = True
Set doc = .Documents.Add
doc.SaveAs CurrentProject.Path & "\TestDoc.docx"
At the moment it is saving in the project folder. I am trying to change it so it saves to another location.
I have tried doc.SaveAs "C:\location\" & "\Doc.docx" but it wont accept. any help appreciated