贴一段将rs记录集转成HTML文档表格的代码(文本框的东西很简单,自己分析吧):Public Function mkHtml(rs As Recordset) As String Dim i As Long Dim j as integer Dim SM as integer Dim StrHtml As String
SM = rs.fields.count SN = rs.recordcount StrHtml = "<html>" & vbCrLf & vbCrLf
mkHtml = strHtml End Functionprivate command1_click() dim Str as string str = mkHtml Open App.Path & "\tmp.html" For Output As #1 Print #1, Str Close #1 end sub
Dim i As Long
Dim j as integer
Dim SM as integer
Dim StrHtml As String
SM = rs.fields.count
SN = rs.recordcount StrHtml = "<html>" & vbCrLf & vbCrLf
StrHtml = StrHtml & "<head>" & vbCrLf
StrHtml = StrHtml & "<meta http-equiv=" & Chr$(34) & "Content-Language" & _
Chr$(34) & " content=" & Chr$(34) & "zh-cn" & Chr$(34) & ">" & vbCrLf
StrHtml = StrHtml & "<meta http-equiv=" & Chr$(34) & "Content-Type" & Chr$(34) & " content=" & _
Chr$(34) & "text/html; charset=gb2312" & Chr$(34) & ">" & vbCrLf
StrHtml = StrHtml & "<meta name=" & Chr$(34) & "GENERATOR" & Chr$(34) & " content=" & _
Chr$(34) & "Microsoft FrontPage 4.0" & Chr$(34) & ">" & vbCrLf
StrHtml = StrHtml & "<meta name=" & Chr$(34) & "ProgId" & Chr$(34) & " content=" & _
Chr$(34) & "FrontPage.Editor.Document" & Chr$(34) & ">" & vbCrLf
StrHtml = StrHtml & "<title>财务报表</title>" & vbCrLf
StrHtml = StrHtml & "</head>" & vbCrLf & vbCrLf
StrHtml = StrHtml & "<body>" & vbCrLf & vbCrLf
StrHtml = StrHtml & "<p align=" & Chr$(34) & "center" & Chr$(34) & "><font size=" & _
Chr$(34) & "6" & Chr$(34) & "><b>财务报表</b></font></p>" & vbCrLf
StrHtml = StrHtml & "<p align=" & Chr$(34) & "left" & Chr$(34) & ">时间:2003年2月</p>" & vbCrLf
StrHtml = StrHtml & "<p align=" & Chr$(34) & "left" & Chr$(34) & ">会计:</p>" & vbCrLf
StrHtml = StrHtml & "<p align=" & Chr$(34) & "left" & Chr$(34) & ">说明:</p>" & vbCrLf
StrHtml = StrHtml & "<p align=" & Chr$(34) & "left" & Chr$(34) & "> </p>" & vbCrLf
StrHtml = StrHtml & " <table border=" & Chr$(34) & "1" & Chr$(34) & " width=" & _
Chr$(34) & "100%" & Chr$(34) & ">" & vbCrLf rs.MoveFirst
For i = 1 To SN
For j = 0 to (SM-1)
StrHtml = StrHtml & " <tr>" & vbCrLf
StrHtml = StrHtml & " <td width=" & Chr$(34) & "10%" & Chr$(34) & ">" & DB.Fields(j) & "</td>" & vbCrLf
StrHtml = StrHtml & " </tr>" & vbCrLf
next j
rs.MoveNext
Next i
StrHtml = StrHtml & " </table>" & vbCrLf
'StrHtml = StrHtml & "<p align=" & Chr$(34) & "left" & Chr$(34) & "> </p>" & vbCrLf & vbCrLf
StrHtml = StrHtml & "</body>" & vbCrLf & vbCrLf
StrHtml = StrHtml & "</html>" & vbCrLf & vbCrLf
mkHtml = strHtml
End Functionprivate command1_click()
dim Str as string
str = mkHtml
Open App.Path & "\tmp.html" For Output As #1
Print #1, Str
Close #1
end sub
我要的是把rtf格式的文本转成HTML格式.
word里面有这个功能,可以借鉴