|
|
MS Word - Экспорт данных формы в MS Word (простой пример)
Код из примера:
Private Sub cmdToWord_Click()
Dim app As Object
Dim strDOC As String
Dim strDOT As String
On Error GoTo cmdToWord_Click_Err
With Application.CurrentProject
strDOT = .Path & "\" & "Word_Tempalate_03.dot"
strDOC = .Path & "\" & "Exported.doc"
End With
Set app = CreateObject("Word.Application")
app.Documents.Add strDOT
app.Visible = True
app.Activate
With app.ActiveDocument
.Bookmarks.Item("Фамилия").Range.Text = Me!txtФамилия & ""
.Bookmarks.Item("Имя").Range.Text = Me!txtИмя & ""
.Bookmarks.Item("Отчество").Range.Text = Me!txtОтчество & ""
.SaveAs strDOC
End With
cmdToWord_Click_End:
On Error Resume Next
Set app = Nothing
Err.Clear
Exit Sub
cmdToWord_Click_Err:
MsgBox "Error " & Err.Number & " (" & Err.Description & ") in Sub cmdToWord_Click.", vbCritical, "Произошла ошибка!"
Err.Clear
Resume cmdToWord_Click_End
End Sub



MSA-2007 ( 88 kB) Пример
|
|