16,721
社区成员




Private Sub Button47_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button47.Click
'检测结果保存至word文件
If TextBox24.Text = Nothing Then '判断是否已经完成行低压负荷表检测
MsgBox("请先执行低压负荷表检测步骤!", MessageBoxIcon.Exclamation)
Exit Sub
End If
Dim WordApp As Word.Application '声明word对象
Dim WordFile As Word.Document '声明文档对象
Dim FileSave As New SaveFileDialog '保存文件对话框
Dim SavePath As String '文件保存路径
WordApp = New Word.Application '实例化doc对象
WordApp.Visible = False '隐藏doc文件
FileSave.Filter = "Word File(*.docx)|*.docx|Word File(*.doc)|*.doc" '保存为docx文件或者doc文件
FileSave.ShowDialog() '显示保存文件对话框
SavePath = FileSave.FileName '文件保存路径
If SavePath = Nothing Then '如果未保存文件,则退出过程
Exit Sub
End If
If Not File.Exists(SavePath) Then '文件不存在则创建文件
WordApp.Documents.Add.SaveAs(SavePath)
Else
'文件存在则删除至回收站,重新创建文件
My.Computer.FileSystem.DeleteFile(SavePath, FileIO.UIOption.OnlyErrorDialogs, FileIO.RecycleOption.SendToRecycleBin, FileIO.UICancelOption.DoNothing)
WordApp.Documents.Add.SaveAs(SavePath)
End If
WordFile = WordApp.Documents.Open(SavePath, Nothing) '打开文件
WordApp.Visible = False '文件隐藏
WordApp.Selection.TypeText("低压负荷统计表检测结果") '写入标题
WordApp.Selection.TypeParagraph() '插入空行
WordApp.Selection.TypeText(TextBox24.Text) '写入检测结果
WordFile.Save()
WordApp.Quit() '结束wordApp对象
System.Runtime.InteropServices.Marshal.ReleaseComObject(WordApp)
WordApp = Nothing '释放wordApp对象
MsgBox("文件已保存至:" & SavePath & "!", MessageBoxIcon.Information)
End Sub