Code:
wdPath = "T:\DMT Ltd\Word Docs\" strPath = "T:\DMT Ltd\Word Docs\Inverviews\"
wdFile = "Questionaire Front Page.docx"
strInput = INputBox("Enter Applicants Name ?")
strTitle = vbTab & "Interview: " & strInput & "|"
Set oWord = CreateObject(Class:="Word.Application")
oWord.Visible = True
oWord.Documents.Open Filename:=wdPath & wdFile
'Form here Add Table
' Set wd = oWord.Documents.Add(wdPath & wdFile, , , True)
' With oWord
'Set wdTbl = wd.Tables.Add(wd.Paragraphs.Add(wd.Paragraphs(12).Range).Range, 1, 2)
' wdTbl.Borders.Enable = True
' With wdTbl.Range.Font
' .Name = "Times New Roman"
' .Size = 11
' End With
' Set wdRw = wdTbl.Rows.Add()
' wdRw.Cells(1).Range.Text = strTitle
' wdRw.Cells(2).Range.Text = Format(Now(), "dddd-dd-mmm-yyyy")
'To Here
With oWord
oWord.selection.MoveDown unit:=wdParagraph, Count:=14
oWord.selection.Text = Format(Now(), "dddd-dd-mmm-yyyy")
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(strTitle, "|", vbNewLine & vbNewLine)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = strLine & vbNewLine
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ1, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ2, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ3, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ4, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ5, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ6, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ7, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ8, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ9, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ10, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ11, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ12, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ13, "|", vbNewLine & vbNewLine), "\", vbTab)
oWord.selection.MoveDown unit:=wdParagraph, Count:=2
oWord.selection.Text = Replace(Replace(strQ14, "|", vbNewLine & vbNewLine), "\", vbTab)
End With
Set oWord = Nothing
Application.FollowHyperlink wdPath & wdFile