none
addin vb6 development, non-administrative does not perform work_open events. RRS feed

All replies

  • office 2010

    windows7


    • Edited by ice.c Wednesday, April 17, 2013 6:57 AM
    Wednesday, April 17, 2013 6:57 AM
  • Hi Ice.c,

    Thank you for posting in the MSDN Forum.

    Do you mean that your add-in does not work under non-administrator account?

    Have you checked Excel options -> Add-Ins tab whether your add-in is in Active Application Add-ins list?

    I look forward to your reply.

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, April 18, 2013 9:23 AM
    Moderator
  • Problem description:
    Vb6 development Excel system.addin com component, in Windows 7, office2010 test found in the environment. The non-system administrator of the Excel is opened, of the following would happen:
    1, cannot perform workbook_open events
    2, can perform "achieve addin interface methods"
    3, can add buttons to Excel
    4, can execute button events
    If the switch to system administrator, everything was normal.
    (individual computer problems this!)
    Use method:
    1, com components are encapsulated into a cab packages, web page automatic installation.
    2, after installing the plug-in, via web page button to open the Excel, before open the Excel com components registered into Excel add-in.
    3, calling Excel workbook_open events.
    Friday, April 19, 2013 1:54 AM
  •  问题描述:
         vb6开发的 Excel addin com组件,在windows7,office2010的环境中测试发现。非系统管理员在Excel被打开的时候,会出现如下情况:
        1、不能执行workbook_open事件
        2、能执行“实现addin接口的方法”
        3、能给Excel添加按钮
        4、能执行按钮的事件
        如果切换成系统管理员,一切正常。
       (个别电脑存在此问题!)
       使用方式:
       1、com组件被封装成cab包,网页上自动安装。
       2、安装完插件后,通过网页按钮打开Excel,在打开Excel之前将com组件注册成Excel加载项。
       3、调用Excel的workbook_open事件。
    Saturday, April 20, 2013 2:33 AM
  • help!!!!!!!!!!!!!!
    Monday, April 22, 2013 12:20 PM
  • 问题描述:
         vb6开发的 Excel addin com组件,在windows7,office2010的环境中测试发现。非系统管理员在Excel被打开的时候,会出现如下情况:
        1、不能执行workbook_open事件
        2、能执行“实现addin接口的方法”
        3、能给Excel添加按钮
        4、能执行按钮的事件
        如果切换成系统管理员,一切正常。
       (个别电脑存在此问题!)
       使用方式:
       1、com组件被封装成cab包,网页上自动安装。
       2、安装完插件后,通过网页按钮打开Excel,在打开Excel之前将com组件注册成Excel加载项。
       3、调用Excel的workbook_open事件。

    Problem description:
    Vb6 development Excel system.addin com component, in Windows 7, office2010 test found in the environment. The non-system administrator of the Excel is opened, of the following would happen:
    1, cannot perform workbook_open events
    2, can perform "achieve addin interface methods"
    3, can add buttons to Excel
    4, can execute button events
    If the switch to system administrator, everything was normal.
    (individual computer problems this!)
    Use method:
    1, com components are encapsulated into a cab packages, web page automatic installation.
    2, after installing the plug-in, via web page button to open the Excel, before open the Excel com components registered into Excel add-in.
    3, calling Excel workbook_open events.
    Wednesday, April 24, 2013 3:34 AM
  • The event involves calling Excel object model, which has COM class in registry. My suggestion is:

    1. Launch the Process Monitor, let it run.
    2. Run your addin. Fire the workbook event.
    3. Stop capturing events in Process Monitor.

    Look in the log, see if there're events with results: Access Denied?


    Forrest Guo | MSDN Community Support | Feedback to manager

    Wednesday, April 24, 2013 1:57 PM
    Moderator
  • hello ice?

    Forrest Guo | MSDN Community Support | Feedback to manager

    Wednesday, May 15, 2013 7:02 AM
    Moderator