CF_HTML 為註冊剪貼板格式(非預設常數),值在 0xC000-0xFFFF 間,需呼叫 RegisterClipboardFormat("HTML Format") 取得。
Private Declare Function RegisterClipboardFormat Lib "user32" Alias "RegisterClipboardFormatA" _
(ByVal lpString As String) As Long
Dim CF_HTML As Long
Const RegHtml As String = "HTML Format"
CF_HTML = RegisterClipboardFormat(RegHtml)
Version:1.0
StartHTML:0000000258
EndHTML:000001491
StartFragment:000001172
EndFragment:000001411
<!--StartFragment--> / <!--EndFragment-->Public Function HtmlDescribed(ByVal Fragment As String) As String
Dim Data As String, nPos As Long
Const Description As String = "Version:1.0" & vbCrLf & _
"StartHTML:aaaaaaaaaa" & vbCrLf & "EndHTML:bbbbbbbbbb" & vbCrLf & _
"StartFragment:cccccccccc" & vbCrLf & "EndFragment:dddddddddd" & vbCrLf
Const FragmentStart = "<!--StartFragment-->"
Const FragmentEnd = "<!--EndFragment-->"
Const Fmt As String = "0000000000"
' 1. 插入片段標記:尋找 <body> 插入 StartFragment,</body> 前插入 EndFragment
nPos = InStr(1, Fragment, "<body", vbTextCompare)
Select Case nPos
Case 0
Fragment = "<html><body>" & vbCrLf & FragmentStart & Fragment
Case Else
nPos = InStr(nPos, Fragment, ">")
If nPos > 0 And nPos < Len(Fragment) Then
Fragment = Left$(Fragment, nPos) & FragmentStart & Mid$(Fragment, nPos + 1)
End If
End Select
nPos = InStr(1, Fragment, "</body", vbTextCompare)
Select Case nPos
Case 0
Fragment = Fragment & FragmentEnd & vbCrLf & "</body></html>"
Case Else
Fragment = Left$(Fragment, nPos - 1) & FragmentEnd & Mid$(Fragment, nPos)
End Select
' 2. 組裝並填入位移
Data = Description & Fragment
Data = Replace(Data, "aaaaaaaaaa", Format$(Len(Description), Fmt))
Data = Replace(Data, "bbbbbbbbbb", Format$(Len(Data), Fmt))
nPos = InStr(Data, FragmentStart) - 1
Data = Replace(Data, "cccccccccc", Format$(nPos + Len(FragmentStart), Fmt))
nPos = InStr(Data, FragmentEnd) - 1
Data = Replace(Data, "dddddddddd", Format$(nPos, Fmt))
HtmlDescribed = Data
End Function
Dim htmlData As String
htmlData = HtmlDescribed("<b>粗體文字</b>")
' 必須同時提供純文字版本,否則 Word/FrontPage 無法貼上
Dim plainText As String
plainText = Html2Text(htmlData) ' 見下方函數
' 使用 DataObject 或 API SetClipboardData 放入 CF_HTML 與 CF_TEXT
Public Function Html2Text(ByVal Data As String) As String
Dim obj As Object
On Error Resume Next
Set obj = CreateObject("htmlfile") ' MSHTML 解析器
obj.Open
obj.Write Data
Html2Text = obj.Body.InnerText ' 取得渲染後純文字
End Function
優點:無需手寫解析器,自動處理實體、標籤移除、換行。缺點:需 IE 環境、效能稍低。
CF_HTML、CF_UNICODETEXT、CF_TEXT、CF_RTF 以相容最多應用程式IStream / IDataObject 介面而非 SetClipboardData