Dim lkt As String
Dim flt As String
lkt = e.Link.Text
If lkt.Contains("营销费") And lkt.Contains("目前") Then '如果shzt包含"审核中"
flt = " 费用分期 = ‘" & lkt.SubString(4,3) & “’”
Tables("合同or费用台账").Filter = flt
MainTable = Tables("合同or费用台账")
End If
参考:
http://www.foxtable.com/help/topics/1284.htm