Private Sub App_WindowDeactivate(ByVal Doc As Document, ByVal Wn As Window)
Dim xRange As Word.Range
Set xRange = Doc.Range(0, 0)
xRange.InsertBefore (" ")
xRange.Copy
Doc.Undo (1)
End Sub
然后需要做的事情就是,在当前文档(ThisDocument)中使用这些。当初问题就出在这里面的。
Dim X As New EventClassModule
Private Sub Register_Event_Handler()
Set X.App = Word.Application
X.App.StatusBar = "Copy Denied!!"
End Sub
Private Sub Document_Open()
Register_Event_Handler
End Sub
B/S下比C/S下还要简单,你写个代理,在Initialize里写代码如下:
假设你有视图MyView,里面有字段MyField1-5:
Dim s As New NotesSession
Dim db As NotesDatabase
Dim view As notesview
Dim doc As notesdocument
Set db=s.CurrentDatabase
Set view=db.getview("MyView")
Set doc=view.getfirstdocument()
Print {Content-Type:application/vnd.ms-excel}'这是关键!!!
Print |<table align=center bordercolordark=white bordercolorlight=#76cdd6 cellspacing=0 border=1>|
Print |<tr height=22>|
Print |<font size=2 color=red><B>|
Print |<td>字段1</td>|
Print |<td>字段2</td>|
Print |<td>字段3</td>|
Print |<td>字段4</td>|
Print |<td>字段5</td>|
Print |</B></font>|
Print |</tr>|
While Not(doc Is Nothing)
Print |<tr height=22>|
Print |<font size=2 color=black>|
Print |<td>|+Cstr(MyField1(0))+|</td>|
Print |<td>|+Cstr(MyField2(0))+|</td>|
Print |<td>|+Cstr(MyField3(0))+|</td>|
Print |<td>|+Cstr(MyField4(0))+|</td>|
Print |<td>|+Cstr(MyField5(0))+|</td>|
Print |</font>|
Print |</tr>|
Set doc=view.getnextdocument(doc)
Wend
Print |</table>|