JPCOMBES

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 : 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.

 

 

Outcomes