Embed and Automate a Microsoft Excel Worksheet with MFC
-
I followed the tutorial at the following address... http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q184/6/63.asp&NoWebContent=1 It works great! But I would prefer if the excel menu did not merge with my apps menue. Is there anyway to keep the user from seeing and using the excel menu and tool bars? In truth what I would prefer to do would be to embed the excel worksheet or spreadsheet into a dialog box like you can with office xp by using the Microsoft Office Spreadsheet 9.0 activeX Control. Does anyone know if this is possible using office 97? I was able to do it in VB, but not in MFC. Thank you very much. Mardigin
-
I followed the tutorial at the following address... http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q184/6/63.asp&NoWebContent=1 It works great! But I would prefer if the excel menu did not merge with my apps menue. Is there anyway to keep the user from seeing and using the excel menu and tool bars? In truth what I would prefer to do would be to embed the excel worksheet or spreadsheet into a dialog box like you can with office xp by using the Microsoft Office Spreadsheet 9.0 activeX Control. Does anyone know if this is possible using office 97? I was able to do it in VB, but not in MFC. Thank you very much. Mardigin
I was able to remove the formula bar and the Grid headings with the following code. app.SetDisplayFormulaBar(FALSE); Window win = app.GetActiveWindow(); win.SetDisplayHeadings(FALSE); I still want to remove the "Formatting Toolbar" and all of the menus associated with Excel. Anyideas. Classes of interest are --> Menu, MenuBar, MenuBars, MenuItem, MenuItems, Menus, Toolbar, ToolbarButton, ToolbarButtons, Toolbars Sincerely, Mardigin