Re: macro deployment - References DLL issue

Mat and all,

I have inserted the following section in Inno setup:

[Run]
Filename: "{sys}\regsvr32.exe"; Parameters:"{app}\msadomd.dll"

but i get an error:

LoadLibrary("C:\Documents") failed - the specified modifiable has not been
found

P.S: my app is "C:\Documents and Settings\..etc..."

C


"Chris Leroquais" <c.le_roq@xxxxxxxxxxxx> wrote in message
news:447f06f6$0$19687$ba4acef3@xxxxxxxxxxxxxxxxx
Mat,

you have completely answered my question. Thank you very much.
I've used InnoSetup.
According to your message, I need to launch the 'regsvr32 mydll' command
within the InnoSetup project.
Cheers,

Chris


"Mat P:son" <MatPson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:385D4CB1-AAF7-44B6-8D92-FC1777FDA25E@xxxxxxxxxxxxxxxx
Hi there Christophe, here are some bullets that I hope might clarify
things:

1) DLL:s that you've put together must be made available on machines
which
are supposed to run your macro

2) The DLL:s must also be properly registered (using regsvr32 is one way,
but not a very amusing one)

3) All DLL:s used by your DLL:s must also be deployed, provided that you
are
not 110% sure the DLL:s will always be present on the target machines
(for
example, if your DLL:s are developed in VB you have to make sure the VB
run-time is present)

4) The XLA file you've put together (it is an XLA, right?) will find your
DLL:s as long as (1) and (2) are adhered to. However, (3) is required to
make
the add-in *run*

Ideally, the registration process should be done by a proper installer.
There are quite a few commercial ones out there, and a bunch of free
ones --
Wise and InstallShield belong to the former category, and InnoSetup and
NSIS
belong to the latter (really user-friendly MSI-compliant freeware
installers
are harder to find though).

Since it seems you're developing a relatively small-scale app, I would
recommend e.g. InnoSetup, which is very fast to work with, and powerful
as
well (and it doesn't cost USD 5,000 thank you very much :o) The drawback
is
that it does not support MSI (and allegedly never will).

Cheers,
/MP

"christophe.leroquais@xxxxxxxxx" wrote:

Hi,

I have created a macro in Excel. It uses 2 dll that are not built-in in
the Excel and windows system.
To use these dll, I must in the VBA Editor to Add References and
selects the dll files.

Now I have a concern for deploying the macro to other computers.
I'd like to know if for deployment I can make transparent the fact to
Reference the dll?
Can I create a script that use the 'regsvr32 mydll' command and this
would have the same effect as manually Reference the macro in the VBA
Editor?

Thx,

Christophe






.