怎样在EXCEL的VBA中打开一个WORD文件?

2025-03-05 05:08:07
推荐回答(2个)
回答1:

'首先要在vba中引用Microsoft Word 11.0 Object Library
Dim Wdapp As Word.Application
Dim WdDocument As Word.Document
Dim UserFile As String

Private Sub CommandButton1_Click()
Set Wdapp = New Word.Application
UserFile = Wdapp.Path & "\1.doc"
Set WdDocument = Wdapp.Documents.Open("c:\1.doc")
Wdapp.Visible = True
End Sub

回答2:

笔者在Excel和StarCalc中对文件的兼容性进行的实际测试可知,对单元格的内容和文字进行编辑时丝毫也感觉不到有任何不便。打开Word和PowerPoint文档以后,虽然在格式上有所不同,但是在实际应用方面没有任何问题