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