Excel Addin 未出现在某些计算机上
我在客户端安装 Excel 插件时遇到一些困难。我已使用 http://www.clear-lines.com/blog/post/create-excel-2007-vsto-add-in-msi-installation.aspx，已经成功对于大多数人来说用户数。安装程序以管理员身份运行，这似乎工作正常。但是，对于一小部分用户来说，安装不成功 - 创建了注册表项，但在 Excel 启动时加载项不会加载，并且不会出现在加载项列表中。尝试从安装文件夹手动添加它会出现加载项无效的错误。
让事情稍微复杂一点的是，客户端同时使用 Vista 和 XP（尽管所有 Excel 安装都是 2007）。 XP 计算机均未成功安装该插件，而大多数（但不是全部）Vista 计算机均已成功安装。
有没有人有这方面的经验，或者可以指出我哪里出错了？
预先非常感谢，
罗布
I am having some difficulties with installing an Excel addin at my client. I have created an installer for the addin using the instructions at http://www.clear-lines.com/blog/post/create-excel-2007-vsto-add-in-msi-installation.aspx, and it has been successful for the majority of users. The installer was run as an admin and this seemed to work ok. However for a small proportion of users the installation was unsuccessful - the registry entries are created but the addin does not load when Excel starts and does not appear in the addins list. Trying to add it manually from the installation folder gives an error that the addin is not valid.
To complicate matters slightly, the client uses both Vista and XP (although all installations of Excel are 2007). None of the XP machines have installed the addin successfully, whereas most (but not all) of the Vista machines have been successful.
Has anybody had any experience of this, or might be able to point out where I am going wrong?
Many thanks in advance,
Rob
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
XP 和 VISTA 之间的各种用户配置文件路径发生了变化。如果您已经硬连线了任何路径，例如 \Users\username\Application Data 等，则您可能无法在 XP 下正确安装内容，其中路径通常为 \Documents and settings\username\Application Data。
最后，如果插件未加载，唯一的原因是
1) 指向它的注册表项（或者在 VSTO 的情况下指向 MANIFEST）要么不存在，要么不正确。
2）该插件有一些您错过的先决条件或依赖项，并且由于它不存在，因此插件加载器无法加载该插件。
对于 1)，只需检查注册表项中的所有正确值，然后在您的外接程序中添加一个消息框或一些日志记录，以验证它确实至少是最初由 Excel 加载的。
对于2）我会阅读Fusion Loaded Viewer并使用它。 Fusion 是 .net“加载程序”服务，它可以设置为记录有关在哪里寻找先决条件的各种详细信息，哪些先决条件在哪里找到，哪些无法找到。
详细信息请参见
http://www.hanselman.com/blog/BackToBasicsUsingFusionLogViewerToDebugObscureLoaderErrors.aspx
There were changes to various user profile paths between XP and VISTA. If you've hardwired any paths like \Users\username\Application Data, etc, you may not be installing things quite right under XP, where the path would typically be \Documents and settings\username\Application Data.
Finally, if an addin isn't loading, about the only causes are
1) the reg entries pointing to it (or to the MANIFEST in the case of VSTO) either aren't there or aren't right.
2) the addin has some prerequisite or dependency that you've missed, and since it's not there, the addin loader is just failing to load the addin.
For 1), just check the reg entries for all the right values, then add a msgbox or some logging in your addin to verify that it is, indeed, at least being initially loaded by Excel.
For 2) I'd read up on the Fusion Loaded Viewer and use that. Fusion is the .net "loader" service, and it can be setup to log all sorts of detailed info about where it's looking for preqs, which one are found where, and which can't be located.
Details here
http://www.hanselman.com/blog/BackToBasicsUsingFusionLogViewerToDebugObscureLoaderErrors.aspx