The Office Library template has a bug (v5 and v6) that doesn't correctly print Office documents. Due to this bug, if you print a Word or Excel document, the document will be printed twice. This bug has been reported to Lotus development, but it hasn't been solved yet.
In order to solve this problem you can create a new action named "Print Document" in each form: (Paintbrush document, Word document, ExcelWorksheet document, PowerPoint document) with the following code.
- This "Print Action" runs for Office documents and Notes documents. You can use it as a shared action, and use the same action for all documents (Notes and Office).
- It is necessary before printing a Office document that you save the document. In order to prevent errors, the action would be hidden for new documents (Hide when -> @IsNewDoc)
Sub Click(Source As Button) Dim workspace As New NotesUIWorkspace Dim uidoc As NotesUIDocument Dim doc As NotesDocument Set uidoc = workspace.currentDocument Set doc = uidoc.document If Not doc.HasEmbedded Then 'Print the Notes Document Call uidoc.print Else 'Print the Office Document Forall object In doc.EmbeddedObjects Set handle = object.Activate(True) handle.PrintOut End Forall End If End Sub
This was first published in July 2003