IBM出品的東西老是裝完後要再搞一些眉眉角角、才能正常運作。
比方說這次要連接 Informix 資料庫,抓了SDK回來,再次發生莫名問題!
另一種方法也是去找出你安裝後的Port號
直接設給Servicces
--
看到、想到、說到、做到
能夠填平大海的誓言,也比不上邁出一步的價值
是以吾輩此生,再無任何誓言
IBM出品的東西老是裝完後要再搞一些眉眉角角、才能正常運作。
比方說這次要連接 Informix 資料庫,抓了SDK回來,再次發生莫名問題!
;C:\Program Files\IBM\Lotus\Notes\
Sub WordOutOutOut( M_To As String, M_DY As String, M_DM As String, M_DD As String, M_NO As String, M_SP As String, M_SEC As String,M_AH As String,M_Sub As String,M_Body As String,M_MAIN As String,M_BEND As String)--
Dim session As New NotesSession
Set db=session.CurrentDatabase
Set wdoc=session.DocumentContext
DefDocPath="C:\missive_out_sample.dot" '設定路徑
Set oWord = CreateObject("Word.Application")
oWord.Application.Visible = True
oWord.documents.Add DefDocPath, False
Set WordDoc = oWord.activedocument
'=======Go to bookmark=======
WordDoc.Bookmarks("TO").Select
Call oWord.Selection.TypeText(M_To)
WordDoc.Bookmarks("YY").Select
Call oWord.Selection.TypeText(M_DY)
WordDoc.Bookmarks("MM").Select
Call oWord.Selection.TypeText(M_DM)
WordDoc.Bookmarks("DD").Select
Call oWord.Selection.TypeText(M_DD)
WordDoc.Bookmarks("NO").Select
Call oWord.Selection.TypeText(M_NO)
WordDoc.Bookmarks("SPEED").Select
Call oWord.Selection.TypeText(M_SP)
WordDoc.Bookmarks("SECURE").Select
Call oWord.Selection.TypeText(M_SEC)
WordDoc.Bookmarks("ATTACH").Select
Call oWord.Selection.TypeText(M_AH)
WordDoc.Bookmarks("SUBJECT").Select
Call oWord.Selection.TypeText(M_Sub)
WordDoc.Bookmarks("BODY").Select
Call oWord.Selection.TypeText(M_BODY)
WordDoc.Bookmarks("MAIN").Select
Call oWord.Selection.TypeText(M_MAIN)
WordDoc.Bookmarks("BEND").Select
Call oWord.Selection.TypeText(M_BEND)
''==========================
'oWord.documents(1).SaveAs "c:\Tmp\WM20101223.doc"
End Sub