From Excel open Word template then save using filepath name
I am very much a newbie with vba and stuck on what must be the most basic if things.
From Excel I am opening a Word.dotx file, and then copying a range from Excel to a bookmark location in the Word document.
Then I simply want to save the newly created Word document with exactly the same filepath name and location as the template is in but
with .docx file extension and a date stamp of “mmmm” (those will of course be the other way around)
I have read masses of post, but unfortunately all that has done is confuse me even more as to how I proceed, can anybody help me?
Code so far:
Dim wd As Word.Application
Dim wdDoc As Word.Document
Dim WdRange As Word.Range
ThisWorkbook.ActiveSheet.Range("B10:E40").Copy ‘Range on Excel sheet of condensed Timesheets
Set wd = New Word.Application
Set wdDoc = wd.Documents.Open("C:\Users\Me\Documents\MyDocs\ServiceTimes\2014\Timesheets.dotx")
wd.Visible = True
Set WdRange = wdDoc.Bookmarks("Point_1").Range
wdDoc.Bookmarks.Add "Point_1", WdRange
‘Now need to save the new document so Filepath name will read