Thread: addins
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default addins

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

Juggernath wrote:

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?