6 Replies Latest reply on Oct 21, 2010 8:08 AM by andreas

    Printing a Microsoft Office Spreadssheet control contained in a processbook display

    JPCOMBES

      Hi all,


      I'm developping a supervision with processbook using a Microsoft Office Spreadsheet control.

      I'm facing a problem to print out the PB display. The result contains all components of the display except the Microsoft Spreadsheet control.


      Here are version I'm using :

      Processbook : 3.0.15.7

      Microsoft Office Spreadsheet : v11.0


      I was thinking to add a 'Print' button in my display to print out the Office control. For that I record a macro in Excel and it generates the following code "ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True". But i didn't manage to implement it in the VBA 'Click' action of the button.

      My question is: is there a way to print the Office Spreadsheet control directly from the 'File > Print' menu ? If not, how to implement the VBA method to do the print job ?

       

      Any clue / comments on that are very welcome !

       

      Thanks in advance for your help.