我已经写了如下代码
Public Sub Command1_Click()
Dim wordapp As Object
Set wordapp = CreateObject("word.application")
wordapp.Visible = ture
Dim mydoc As Object
Set mydoc = wordapp.Documents.Add
mydoc.Tables.Add Range:=Selection.Range, NumRows:=nLineMS + 1, NumColumns:=3 mydoc.saveas "c:\tempddd.doc"
wordapp.quit
Set mydoc = Nothing
Set wordapp = Nothing
end sub
但VB执行时总是说没有对象??总停在红色那一行????,语句应该没错的,我用带有该语句的宏在word软件里都可以生成一个表格。
Public Sub Command1_Click()
Dim wordapp As Object
Set wordapp = CreateObject("word.application")
wordapp.Visible = ture
Dim mydoc As Object
Set mydoc = wordapp.Documents.Add
mydoc.Tables.Add Range:=Selection.Range, NumRows:=nLineMS + 1, NumColumns:=3 mydoc.saveas "c:\tempddd.doc"
wordapp.quit
Set mydoc = Nothing
Set wordapp = Nothing
end sub
但VB执行时总是说没有对象??总停在红色那一行????,语句应该没错的,我用带有该语句的宏在word软件里都可以生成一个表格。
mydoc.Tables.Add Range:=wordapp.Selection.Range, NumRows:=nLineMS + 1, NumColumns:=3