3个image字段内容一起写到一个WORD文件中怎么弄?【菜鸟求助】
Sub s_ReadFile()
Dim iStm As ADODB.Stream
Dim iRe As ADODB.Recordset
'打开表
Set iRe = New ADODB.Recordset
iRe.Open "select * from sj_1 where id<=3 ", cn, adOpenKeyset, adLockReadOnly
'保存到文件
Set iStm = New ADODB.Stream
With iStm
.Mode = adModeReadWrite
.Type = adTypeBinary
.Open
iRe.MoveFirst
While Not iRe.EOF ' 有三条
.Write iRe.Fields(1)
iRe.MoveNext
Wend
.SaveToFile App.Path & "\test3.doc" '总是只有一条资料被写入。
End With
'关闭对象
iRe.Close
iStm.Close
End Sub
用VBA代码也不懂写。
' Set wdapp = CreateObject("Word.Application")
'Set wddoc = wdapp.Documents.Open("e:\test3.doc ")
' With WordApp
' .Visible = True
' .Activate
' .Selection.TypeText Text:="1: 啊 2: abc"
' .Selection.TypeParagraph
' End With