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