Advertisement
Guest User

Untitled

a guest
Jul 25th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. Sub PopulateWordDoc()
  2.  
  3. Dim wrdApp As Object
  4. Dim wrdDoc As Object
  5. Dim sPath As String
  6. Dim vaBookmarks As Variant
  7. Dim wksBookmarks As Worksheet
  8. Dim newFileName As String
  9. Dim newFilePath As String
  10. Set wrdApp = CreateObject("Word.Application")
  11. Set wrdDoc = CreateObject("word.document")
  12.  
  13. Set wksBookmarks = Sheets("Bookmarks")
  14. vaBookmarks = wksBookmarks.Range("rngBookmarksList").Value
  15. Set wrdApp = CreateObject("Word.Application")
  16. sPath = ThisWorkbook.Path & ""
  17. On Error GoTo errHandler
  18. Set wrdDoc = wrdApp.Documents.Open(sPath & "TemplateFillDocument.dotm")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement