问题描述
我想要的非常简单:我希望我们的用户能够解压缩我给他们的目录,并从中运行应用程序,而这绝对不会造成麻烦. 尤其应该不需要用户具有管理员权限!
我已经可以使用纯VB.NET应用程序执行此操作:现在,我想做同样的事情带有某种Excel组件,该组件实例化并使用来自我们的.NET DLL之一的对象.这样可能吗?
本来想在Visual Basic 2008 Express中做所有事情,但是与COM相关的事情似乎太多了,Express没做,所以我安装了Visual Studio 2008 Pro. 我的第一步是尝试注册COM互操作复选框,但这没有用.我使用受限帐户进行开发,因此VS无法写入注册表.我还意识到,用户将需要一个可写入注册表的安装程序,这意味着我将必须编写一个安装程序,更重要的是,用户将需要管理员权限,因此就不用了.
有一阵子我以为我可以使用免注册COM互操作,但显然这不适用于Office.
所以有什么方法可以调用. NET可以从Excel内进行访问,同时避免注册,或者至少避免需要管理员权限?我发现VS Pro具有用于Excel加载项,工作簿和模板的模板.这些人中有谁会做我想要的吗?
任何建议都将不胜感激!我不希望有人为我编写应用程序,我只是想知道我尝试做的事情是否有可能.
What I want is very simple: I want our users to be able to unzip a directory I give them, and run our applications from it, with an absolute minimum of trouble. In particular the user shouldn't be required to have Administrator privileges!
I can already do this with pure VB.NET applications: now I want to do the same thing with some sort of Excel component that instantiates and uses objects from one of our .NET DLLs. So is this possible?
Originally wanted to do everything in Visual Basic 2008 Express, but there seemed to be too many COM related things Express didn't do, so I installed Visual Studio 2008 Pro. My first effort was to try the Register for COM interop checkbox, but that didn't work. I develop on a Limited Account, so VS couldn't write to the registry. I also realized that the user would need an installer that would write to the registry, which would mean I would have to write an installer, and, more important, the user would need Administrator privileges, so that was out.
For a while I thought I could use Registration-Free COM Interop, but apparently that doesn't work with Office.
So is there any way to call .NET from within Excel while avoiding the registry, or at least avoiding the need for Administrator privileges? I see that VS Pro has templates for Excel Add-ins, Workbooks and Templates. Will any of those do what I want?
Any suggestions or advice will be greatly appreciated! I'm not expecting anybody to write my app for me, I just want to know if what I am trying to do is even possible.
推荐答案
这篇关于用户可以从受限帐户安装任何类型的.NET Excel组件吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!