Deployment 2

113 views
Skip to first unread message

Norbit

unread,
Oct 14, 2009, 11:25:22 PM10/14/09
to ExcelDna
Hi.
Thankyou very much for your help and this software it is excellent.
My question is regarding trying to deploy the xll.
If I have a normal dll I would use regasm to register it, but it
doesnt seem to be the case with the xll file.
If however I wanted to make the xll install silently, Am i able to
alter the register in the Software\\Microsoft\\Office\\12.0\\Excel\
\Options[?]\\
directory as you would for a formuala addin to make it load silently?
Does anyone have knowledge of this?

Govert van Drimmelen

unread,
Oct 15, 2009, 5:45:58 AM10/15/09
to ExcelDna
Hi Norbit,

RegAsm is only needed for COM components. ExcelDna does not work as an
automation server, so needs no registration. You can just copy
the .xll file, .dna file and any .dlls you require into a directory.

If you want to install the .xll add-in to be loaded automatically when
Excel starts, you can add it to the Tools->Add-ins list (Logo button -
> Excel Options -> Add-Ins -> Manage Excel Add-Ins in Excel 2007). You
can make an installer that will add it to Excel, and I think this
works just like it would for an .xll, but I have no experience myself.
I know some ExcelDna-based add-ins have installers that do this -
maybe someone else can explain how to do that part.

Govert

dornakul

unread,
Nov 16, 2009, 12:04:02 PM11/16/09
to ExcelDna
Hello everybody,

I have the same problem with ExcelDna. It is very nice that I can
distribute functions for Excel users, but the installation is quite
complicated for unexperienced users.

Does anybody have a solution?

Dornakul

Govert van Drimmelen schrieb:

Govert van Drimmelen

unread,
Nov 17, 2009, 4:40:25 AM11/17/09
to ExcelDna
Hi,

I would suggest not making it overly complicated.

To get the ExcelDna-based add-in installed, you need to give your
users a list with the following instructions:
1. Install .Net runtime, maybe give the link to the download.
2. Copy the .xll, dna and required .dll file to some directory.
3. Open Excel, select Tools->Add-Ins and select the .xll file.

No other registration is needed for ExcelDna.
I don't think this is too bad...?

Govert
> > > Does anyone have knowledge of this?- Hide quoted text -
>
> - Show quoted text -

Luke Jackson

unread,
Nov 17, 2009, 8:00:08 AM11/17/09
to exce...@googlegroups.com
Hi Dornakul

One simple installation option is to create an Excel sheet with a button on
it. The button then calls the following VBA:

AddIns.Add "<path to add-in>", False

This has worked well for me, along with deploying the add-in and related DLL
files to a folder on a network drive.

With ThisWorkbook.Path and FileSystem or FileSystemObject can you probably
even write a simple installer to copy the required files from where they are
to the program files folder (Environ("PROGRAMFILES")).

Luke
--

You received this message because you are subscribed to the Google Groups
"ExcelDna" group.
To post to this group, send email to exce...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/exceldna?hl=.


Reply all
Reply to author
Forward
0 new messages