Printing a Microsoft Office Spreadssheet control contained in a processbook display

Discussion created by JPCOMBES on Oct 19, 2010
Latest reply on Oct 21, 2010 by andreas

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.