1. Rick Domogalik
  2. PowerBuilder
  3. Friday, 10 July 2020 15:56 PM UTC

I am using an OLE Control to view an Excel Document in my application.  

ole_excel.insertfile(as_filename)

I have the DisplayType set to "Displayascontent!"

This will load the excel file's first tab/page into the control, but I cannot see any other tab or pages as there is not scroll capability with this display type.  Is there a way to make this displaytype more viewable with scroll bars and multiple tabs/pages?

When I switch the DisplayType to "Displayasactivexdocument!', it look great (has all the tabs/pages and scrollbars), but opens the Excel menu (ribbon) and attaches to my application.  This is a problem.  I don't need the menu to open and actually don't want it to open.  This control is meant to be a "preview" only with no editing capabilities in the preview.  Also, once the ole control has been activated, the big ugly green excel menu never goes away until the application closes, even if I deactivate the ole control.

My question is how do I get rid of the excel menu (ribbon).  I have read about "menuoption" and "exclude!", but I don't think this is how you suppress the excel menu.  But I see no other way to turn off the menu.

 

If anyone has used this setup before and turned off the menu, please advise on how to do this.

 

Thanks.

 

Rick

René Ullrich Accepted Answer Pending Moderation
  1. Monday, 13 July 2020 08:27 AM UTC
  2. PowerBuilder
  3. # 1

Hi Rick,

maybe it helps you to hide the ribbon bar?

See here for a way in Excel: https://www.teachexcel.com/excel-tutorial/completely-hide-the-ribbon-menu-in-excel_1321.html

I think you could do it also from Powerbuilder with an OLE call.

HTH,

René

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.