Re: macro deployment - References DLL issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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




.

Relevant Pages

  • Re: macro deployment - References DLL issue
    ... I've used InnoSetup. ... I have created a macro in Excel. ... To use these dll, I must in the VBA Editor to Add References and ... would have the same effect as manually Reference the macro in the VBA ...
    (microsoft.public.excel.programming)
  • Re: macro deployment - References DLL issue
    ... I've used InnoSetup. ... I have created a macro in Excel. ... To use these dll, I must in the VBA Editor to Add References and ... would have the same effect as manually Reference the macro in the VBA ...
    (microsoft.public.excel.programming)
  • Re: macro deployment - References DLL issue
    ... InnoSetup will register your DLL:s if you ask it to. ... you add your DLL. ... copied by the installer to directory specified by the user as the application ... I have created a macro in Excel. ...
    (microsoft.public.excel.programming)
  • Re: macro deployment - References DLL issue
    ... InnoSetup will register your DLL:s if you ask it to. ... you add your DLL. ... installation directory and after copying the file, the installer ... I have created a macro in Excel. ...
    (microsoft.public.excel.programming)