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