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

    Printing a Microsoft Office Spreadssheet control contained in a processbook display


      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 :

      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.