addins

  • Thread starter Thread starter Juggernath
  • Start date Start date
J

Juggernath

I wrote few custom functions and saved it to the xla addin. When I copy a
book that uses my custom function addin to another machine, formulas with
that functions are referenced to the path on my machine
(e:\dir1\dir2\myadin.xla!myfunction(arg1;arg2) ). What I did wrong?
 
You did nothing wrong. AddIn functions are run from the AddIn, not
copied into the each workbook that calls them.

You will need to install your AddIn on the new machine to use that
workbook there. If you install it in a different location than where
you put it on the first machine, then you will have problems moving
files from one machine to the other.

Jerry
 
Thanx, so there is no way to use this sheet and addins that I made on
another machine, and I have to uninstall addins, copy them to office/library
folder which all machines have and then correct formulas in woorkbooks
(which have the old path to addins), and at last copy it to the other
machines.
 
Every machine that uses the AddIn functions must have the AddIn
installed (and in the same location). If you are on a network, you
could put the AddIn on a network drive, and so maintain only one copy
(much easier for updates). This will work for moving workbooks from one
PC to another provided that all PCs access the drive as the same drive
letter.

You would need to register (Tools|AddIns) the AddIn on each PC that
needs it. The result is an entry written to the Windows Registry, so
you could simplfy the process by exporting the Registry entry as a .reg
file. Users could then register the AddIn by simply double clicking on
the .reg file.

Jerry
 
Back
Top