如何让VBA excel addin .xlam替换为远程更新的.xlam？ [英] How to get VBA excel addin .xlam to replace itself by a remote updated .xlam?

问题描述

我需要一些方法来更新我的员工之间共享的excel加载项，这样每个人都不必下载&手动安装。

I need some way to update an excel addin shared among my staffs so as everyone don't have to download & install it manually.

我已经google了，看到我们可以写文件到OS文件系统，所以任务最后写入新版本的插件，即。 xlam文件，以覆盖自己。

I have googled and see that we can write file to the OS file system so the task ends up with writing the new-version addin, i.e. the .xlam file, to overwrite itself.

我不知道如何做到这一点。如果你有，请分享！谢谢！

I have no idea on how to do this. If you do have ones, please share! Thank you!

推荐答案

我使用一个reversioning的加载项管理器来做到这一点：基本上是一个小的xla / xlam，从来没有改变安装在每个用户机器上。它检查网络共享的最新版本的真实插件，并打开它，就像它是一个普通的工作簿：这具有加载真实的Addin（s）为用户的效果。

I use a reversioning addin-manager to do this: basically its a small xla/xlam that never changes thats installed on each users machine. It checks a network share for the latest version of the real addin(s) and opens it as if it was an ordinary workbook: this has the effect of loading the real Addin(s) for the user.

有一个可下载的工作示例，您可以自定义这里

There is a downloadable working example which you can customise here

这篇关于如何让VBA excel addin .xlam替换为远程更新的.xlam？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！