'以下VBA脚本实现标题阐述功能,考虑以下问题:
如何捕获一个Cell单元格的单击事件?Excel 中能否添加处理其他的Windows 消息?'Unit : mcc
'Fun : Goto exactly position in Word from Excel impls by VBA.
'args : Bookmark string(predefined in Word handed yourself or using tools)
'ref : Ms Word/Excel object lib.
'modify : 1.open word archives in readonly way 2.get abs path using for anchor
'future : 1.search by string exactly
'Author : qjwxsd
'DT : 2005-04-18~~
Const TC3 = 'TC03_軟体版權管理\TC03_Software license management'
Const TC4 = 'TC04_配備資源管理\TC04_Periphery resource'
Const TC10 = 'TC10_資料安全管理\TC10_Data security management'
Public Sub gotoWord(FileName, Bookmark As String)
On Error Resume Next
Dim a As Word.Application
Dim b As Word.Document
Dim c As Excel.Application
Dim d As Excel.Workbook
Dim e As Excel.Worksheet
Dim path As String
Set c = GetObject(, 'Excel.Application')
Set d = c.ActiveWorkbook
Set e = d.ActiveSheet
'path = c.path
path = d.path
'取得当前功能清单的路径,传到Word中。否则Word无法取得路径,
'打开相应的TC。
Set a = GetObject(, 'Word.Application')
If a = Null Then
Set a = CreateObject('Word.Application')
End If
'a.Documents.Open 'H:\0408\PCmain5.5.0 _Other.doc'
'MsgBox a.Path
'MsgBox Application.Path
'MsgBox CurDir
'MsgBox a.Documents.Item(0).FullName
a.Documents.Open path & '\' & FileName & '.doc', ReadOnly:=True
a.Selection.GoTo what:=wdGoToBookmark, Name:=Bookmark
a.Visible = True
a.Activate '前台显示Word窗体
End Sub
Private Sub Label1_Click()
gotoWord TC3, 'TC3_1'
End Sub
Private Sub Label10_Click()
gotoWord TC4, 'TC4_4'
End Sub