none
The 'ActionsPane' doesn´t appears (Ref.: VB / Excel 2010 / Document Level Project) RRS feed

  • General discussion

  • Hello,

    I´m using VS2010 Professional.

    I have problems to manage the ActionsPane in an Excel 2010 workbook level project (Visual Basic).

    I add a ‘User control’ named UserControl with one label and one button (only for testing purpose), and wrote the following code inside ThisWorkbook.vb

    Public Class ThisWorkbook
    
        Dim MiControl As New UserControl
    
        Private Sub ThisWorkbook_Startup() Handles Me.Startup
           Me.ActionsPane.Controls.Add(MiControl)
           Me.ActionsPane.Visible = True
        End Sub
    
    End Class
    

    After pressing F5 no error appears, the workbook opens normally, but the ActionsPane doesn´t appears.

    I noticed that in the ‘Show’ group of the ‘View’ tab of the Ribbon a new button named ‘Documents Actions’ appears but when it is pressed nothing ocurrs.

    What is wrong? How to do the ActionsPane appears and works normally?

    Is it possible that some wrong Excel configuration option may be the problem?

    I´d appreciate very much your help.

    Hernán



    Hernán Carminatti Buenos Aires - Argentina

    Tuesday, May 8, 2012 5:51 PM

All replies

  • Hi Hernán Carminatti,

    Welcome to MSDN Forum.

    I have copied your code into my project and everything is fine. So for further troubleshooting, I suggest you to use the code below to see if there are some exceptions.

    Code Snippet:

    Private Sub ThisWorkbook_Startup() Handles Me.Startup
    
        Try
            Me.ActionsPane.Controls.Add(MiControl)
            Me.ActionsPane.Visible = True
        Catch ex As Exception
            MsgBox("Can't load ActionsPane" & vbCrLf & ex.Message)
        End Try
    
    End Sub

    I'm looking forward to your reply.

    Best Regards,
    Quist


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us

    Thursday, May 10, 2012 6:09 AM
    Moderator
  • Hi Quist!

    Thanks for your quick answer.

    I've tried your code snippet but the ActionsPane doesn´t appear.

    What follows is the report (spanish) that appears in the Result window (from debuging) after closing the workbook:

    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_32\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.

    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Tools.Office.Runtime\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Tools.Office.Runtime.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\mscorlib.resources\v4.0_4.0.0.0_es_b77a5c561934e089\mscorlib.resources.dll'
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Tools.Applications.Hosting\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Tools.Applications.Hosting.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Tools.Applications.ServerDocument\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Tools.Applications.ServerDocument.dll'
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Tools.Applications.Runtime\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Tools.Applications.Runtime.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Tools.Office.Runtime.resources\v4.0_10.0.0.0_es_b03f5f7f11d50a3a\Microsoft.VisualStudio.Tools.Office.Runtime.resources.dll'
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Deployment\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Deployment.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Deployment.resources\v4.0_4.0.0.0_es_b03f5f7f11d50a3a\System.Deployment.resources.dll'
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.Linq.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    El subproceso 'InstallerThread' (0x1230) terminó con código 0 (0x0).
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.Office.Tools\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.Office.Tools.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.Office.Tools.Excel.Implementation\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.Office.Tools.Excel.Implementation.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.Office.Tools.Common.Implementation\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.Office.Tools.Common.Implementation.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.Office.Tools.Excel\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.Office.Tools.Excel.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Users\heca.CORRIENTES\AppData\Local\assembly\dl3\D5XOQD0X.76V\O872XKVG.XG6\cb76a664\34864121_cb2ecd01\TestingCustomTaskPanelDocLev.DLL', símbolos cargados.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Users\heca.CORRIENTES\AppData\Local\assembly\dl3\D5XOQD0X.76V\O872XKVG.XG6\a1711944\00108d6e_56b7cb01\Microsoft.Office.Tools.Excel.v4.0.Utilities.DLL'
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.Office.Tools.Common\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.Office.Tools.Common.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll', se omitió la carga de símbolos. Se optimizó el módulo y se habilitó la opción 'Solo mi código'.
    'Excel.exe' (Administrado (v4.0.30319)): se cargó 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Accessibility\v4.0_4.0.0.0__b03f5f7f11d50a3a\Accessibility.dll'
    El programa '[5924] Excel.exe: Administrado (v4.0.30319)' terminó con código 0 (0x0).

    Thank you very much for your help.

    Regards,


    Hernán Carminatti

    Thursday, May 10, 2012 4:56 PM
  • Hi Hernán,

    I noticed you have named your user control as "UserControl", but this very name is preserved in .NET Class Library.  Please use unique name or leave the default name as is.

    best regards,


    Forrest Guo | MSDN Community Support | Feedback to manager

    Friday, May 11, 2012 7:41 AM
    Moderator
  • Hi Forrest,

    Thanks for responding.

    Before resorting to the forum I tried different names, and associating to *.xlsx and *.xlsm too, but the issue persists: ActionsPane does not appear but the whole process seems to be correct.

    What strikes me are the messages as in my previous statement attac.

    I am puzzled by this.

    Best regards,


    Hernán Carminatti

    Friday, May 11, 2012 4:22 PM
  • Hello,

    I´m using VS2010 Professional.

    I have problems to manage the ActionsPane in an Excel 2010 workbook level project (Visual Basic).

    I add a ‘User control’ named UserControl with one label and one button (only for testing purpose), and wrote the following code inside ThisWorkbook.vb

    Public Class ThisWorkbook
    
        Dim MiControl As New UserControl
    
        Private Sub ThisWorkbook_Startup() Handles Me.Startup
           Me.ActionsPane.Controls.Add(MiControl)
           Me.ActionsPane.Visible = True
        End Sub
    
    End Class

    After pressing F5 no error appears, the workbook opens normally, but the ActionsPane doesn´t appears.

    I noticed that in the ‘Show’ group of the ‘View’ tab of the Ribbon a new button named ‘Documents Actions’ appears but when it is pressed nothing ocurrs.

    What is wrong? How to do the ActionsPane appears and works normally?

    Is it possible that some wrong Excel configuration option may be the problem?

    I´d appreciate very much your help.

    Hernán



    Hernán Carminatti Buenos Aires - Argentina

    Hi,

    Take the above code as example, I mean the class name "UserControl" is reserved.  Before this code, you should have created a user control. This defines new class.  Please do not name the user control as "UserControl". This is base class in .NET class library.

    MiControl as the instance name is OK.

    Please let me know if it's not clear.

    best regards,


    Forrest Guo | MSDN Community Support | Feedback to manager

    Saturday, May 12, 2012 4:43 AM
    Moderator
  • Hi Forrest,

    Thanks for your answer.

    I think the problem is not in the name of the control, I´ve tried many differents names but the problem persists.

    I get the feeling that the problem is in some very specific configuration of the Excel application or VS2010.

    Is it possible that the problem is with something related to the symbols ? (see the my previous answer)

    Definitely the problem is not obvious, but it is probably something contrived and so I resorted to the forum.

    I´d appreciate very much the forum help.

    Regards.


    Hernán Carminatti

    Sunday, May 13, 2012 2:06 PM
  • Hi, Hernán

    I'm not sure if you made changes in code since original post, but the original code was constructing control object of incorrect type. Would you please send me the project: forrestg@microsoft I'll try to diagnose the problem.

    best regards,


    Forrest Guo | MSDN Community Support | Feedback to manager

    Sunday, May 13, 2012 4:25 PM
    Moderator