将 VSTO 文档解决方案部署到 Excel 2003

发布于 2024-09-09 12:09:18 字数 981 浏览 8 评论 0原文

我们有一个 Excel 工作簿,其中包含 C# VSTO 代码和位于其后面的两个 .NET DLL。该电子表格过去适用于组织中的所有用户。

最近,我们的 IT 部门遇到了 OU 的问题,删除了所有用户帐户。帐户已恢复,但从那时起,我们伦敦办事处的用户在加载电子表格时就无法使用附加功能。只有纽约办事处的用户和一名开发人员(此后编译了该解决方案)可以使用该功能。

  • 这些文件全部保存在共享网络驱动器上的一个目录中。
  • 我们已调整清单以反映此位置。
  • 我们已将该目录添加为受信任站点,以确保计算机上的代码访问安全。
  • Office 2003 PIA 已安装并正常工作,因为我们在计算机上安装了另一个应用程序级扩展,并且工作正常。
  • .NET Framework 3.5 已安装在所有计算机上 - 正如应用程序扩展所证明的那样。
  • VSTO 2005 SE 运行时已安装。

    我们从互联网上遵循了一些操作方法,但没有成功,包括: http://msdn.microsoft.com/en-us/library/ bb332051.aspx#8

    我们怀疑存在安全问题,因为我们代码的第一行是日志消息,但没有被命中。

    Excel 没有给出错误消息,电子表格打开并且可用,但无法访问任何代码,并且所有按钮均被禁用。

    任何帮助将不胜感激,因为我们花了很多时间试图解决这个问题!

    谢谢

    ****************编辑********************************< /p>

    以下是我的 IT 部门提供的问题的实际原因:

    ...是由它们所在的组织单位容器引起的 
    已删除。这已恢复,组成员资格和通讯组列表访问
    然后手动添加个人帐户
    
  • We have an Excel workbook which has c# VSTO code in it and two .NET DLLs that sit behind it. The spreadsheet used to work for all users in the organisation.

    Recently our IT department had a problem with the OU which deleted all user accounts. The accounts were restored but since then users in our London office have not had the added functionality when they load the spreadsheet. Only users in the New York office and one developer (who has compiled the solution since) can use the functionality.

  • The files are all held in one directory on a shared network drive.
  • We have adjusted the manifest to reflect this location.
  • We have added the directory as a trusted site for code access security on the machine.
  • The office 2003 PIAs are installed and working as we have another application level extension installed on the machines and this is working correctly.
  • The .NET framework 3.5 is installed on all machines - as evidenced by the application extension.
  • VSTO 2005 SE Runtime is installed.

    We've followed several how-to's from the internet to no avail, including:
    http://msdn.microsoft.com/en-us/library/bb332051.aspx#8

    We have a suspicion that there is a security problem as the first line of our code is a logging message and this is not being hit.

    No error message is given by excel, the spreadsheet opens and is usable but there is no access to any code and all buttons are disabled.

    Any help would be massively appreciated as we've spent many hours trying to figure this out!

    Thanks

    ***************EDIT******************************

    Here's the actual cause of the problem from my IT Dept:

    ...was caused by the Organisational Unit container they were held in being 
    deleted. This was restored and group memberships and distribution lists access
    for individual accounts were then added manually
    
  • 如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

    扫码二维码加入Web技术交流群

    发布评论

    需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

    评论(1

    梦初启 2024-09-16 12:09:23

    事实证明,问题在于周末 IT 部门已将我们所有的 Excel 版本从专业版降级为标准版。并非所有 VSTO 都适用于 Excel Standard,但它并没有告诉您这一点,它只是不起作用。

    升级后我们又开心了!

    干杯

    Turns out the problem was that over the weekend IT had downgraded all our versions of Excel from Professional to Standard. Not all VSTO works in Excel Standard, but it doesn't tell you this, it just doesn't work.

    After upgrading we're all happy again!

    Cheers

    ~没有更多了~
    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
    原文