技术开发 频道

MS Word实现Batch打印Notes文档

' Equipment and location

    ‘下面这些是垃圾.为了保证打印的完整性.

    If reqdoc.equipment1<>"" Then

    Call SetBookmark ( WordDoc , "equipment1"  , reqdoc.equipment1(0) )

    Call SetBookmark ( WordDoc , "location1"  , reqdoc.location1(0) )

    End If

    If reqdoc.equipment2<>"" Then

    Call SetBookmark ( WordDoc , "equipment2"  , reqdoc.equipment2(0) )

    Call SetBookmark ( WordDoc , "location2"  , reqdoc.location2(0) )

    End If

    If reqdoc.equipment3<>"" Then

    Call SetBookmark ( WordDoc , "equipment3"  , reqdoc.equipment3(0) )

    Call SetBookmark ( WordDoc , "location3"  , reqdoc.location3(0) )

    End If

    If reqdoc.equipment4<>"" Then

    Call SetBookmark ( WordDoc , "equipment4"  , reqdoc.equipment4(0) )

    Call SetBookmark ( WordDoc , "location4"  , reqdoc.location4(0) )

    End If

    If reqdoc.equipment5<>"" Then

    Call SetBookmark ( WordDoc , "equipment5"  , reqdoc.equipment5(0) )

    Call SetBookmark ( WordDoc , "location5"  , reqdoc.location5(0) )

    End If

    If reqdoc.equipment6<>"" Then

    Call SetBookmark ( WordDoc , "equipment6"  , reqdoc.equipment6(0) )

    Call SetBookmark ( WordDoc , "location6"  , reqdoc.location6(0) )

    End If

    If reqdoc.equipment7<>"" Then

    Call SetBookmark ( WordDoc , "equipment7"  , reqdoc.equipment7(0) )

    Call SetBookmark ( WordDoc , "location7"  , reqdoc.location7(0) )

    End If

    If reqdoc.equipment8<>"" Then

    Call SetBookmark ( WordDoc , "equipment8"  , reqdoc.equipment8(0) )

    Call SetBookmark ( WordDoc , "location8"  , reqdoc.location8(0) )

    End If

    If reqdoc.equipment9<>"" Then

    Call SetBookmark ( WordDoc , "equipment9"  , reqdoc.equipment9(0) )

    Call SetBookmark ( WordDoc , "location9"  , reqdoc.location9(0) )

    End If

    If reqdoc.equipment10<>"" Then

    Call SetBookmark ( WordDoc , "equipment10"  , reqdoc.equipment10(0) )

    Call SetBookmark ( WordDoc , "location10"  , reqdoc.location10(0) )

    End If

    If reqdoc.equipment11<>"" Then

    Call SetBookmark ( WordDoc , "equipment11"  , reqdoc.equipment11(0) )

    Call SetBookmark ( WordDoc , "location11"  , reqdoc.location11(0) )

    End If

    If reqdoc.equipment12<>"" Then

    Call SetBookmark ( WordDoc , "equipment12"  , reqdoc.equipment12(0) )

    Call SetBookmark ( WordDoc , "location12"  , reqdoc.location12(0) )

    End If

    ‘垃圾结束.

    ' file name for extracting and attaching

    wordPODocName = pathName & fileName & reqDoc.WorkOrderNum(0) & fileExt

    ‘这句非常关键,如果使用原来的名字,则原来的word文档就被冲掉了.

    WordDoc.SaveAs  wordPODocName , wdFormatDocument

    WordDoc.Application.PrintOut

    ' clean up word objects

    WordDoc.Close

    WordDoc = Null

    WordObj = Null

    Exit Sub

    ErrorHandler:

    errMsg="Error in Common.CreateWordPO  " & Str$(Err) & ": " & Error$ & "-- Line: #>" & Cstr(Erl)

    ' WriteErrDoc ( errMsg )

    Resume Next

    End Sub

    Function SetBookmark( wrdDoc As Variant, fieldName$, itemValue$ ) As Integer

    ' Set's the value of a bookmark in a Word document

    On Error Goto ErrorHandler

    Dim range As Variant

    On Error Goto ErrorHandler

    Set range = wrdDoc.Bookmarks( fieldName$ ).range

    range.end = range.end

    range.text = itemValue$

    SetBookmark = True

    Exit Function

    ErrorHandler:

    Dim errMsg$

    errMsg= "Error in Common.SetBookmark  " & Str$(Err) & ": " & Error$ & "-- Line: #>" & Cstr(Erl)

    ' WriteErrDoc ( errMsg )

    SetBookmark = False

    Exit Function

    End Function

    WO_DOC.zip
 

0
相关文章