none
Remove excel document action pane RRS feed

  • Question

  • We can attach document action pane to any excel file using Developer-> expansion pack-> Microsoft action pane -> attach.

    Once the excel is saved and opening it again will have previously stored excel document.

    I have an Excel file (refer image[http://i.stack.imgur.com/jYcwl.png]) and I wish to remove(detach) document action pane using inter op programming in c#. Is it possible do so?

    code snippet :

    Application xlApp = null;
    try
         {
            xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
            string versionNo = xlApp.Version;
            xlApp.Visible = true;
            Microsoft.Office.Core.MsoAutomationSecurity mso = xlApp.AutomationSecurity;
            xlApp.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityForceDisable;
            Workbook newWb = xlApp.Workbooks.Open(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
    
             // Here want code to detach document action pane.
        }

    Friday, April 12, 2013 4:36 AM

Answers

All replies